Usually, which is more important for DB2 system
performance - CPU processing or I/O access?
Answer / s
I/O is expensive as most the the CPU time is wasted doing
I/O's
| Is This Answer Correct ? | 2 Yes | 1 No |
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is a correlated sub query?
How does db2 sample database connect?
What is copy pending status in db2?
Which component is responsible for processing sql statements and selecting access paths?
What is image copy?
What is a cursor in programming?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What information can you find in SYSIBM.SYSLINKS table?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
Explain the contents that are a part of dclgen.