Usually, which is more important for DB2 system
performance - CPU processing or I/O access?
- 1 Answers
- 3918 Views
- I also Faced
- E-Mail Answers
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 |
What is a db2 cursor?
how can we retrieve the 100 records of the file ?
Mention some fields that are a part of sqlca.
What's The Error Code For Unique Index Voilation?
can we update the table by using cursors can anyone post the query?
how to resolve -818 error. how to see timestamp token in load module and plan
Which component is used to execute the sql statements?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What is the maximum length of sqlca?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is the cascade rule and how does it relate to deletions made with a subselect?
COBOL 
