Expert Answer Center (Craig Mullins) 2ème partie

Bonjour,

Vous trouverez ci-dessous une deuxième série de 15 questions posées à Craig Mullins sur DB2 pour z/OS dans la rubrique Expert Answer Center du site web TechTarget :

- Runstats command to update all columns of multi-column index
- How much CPU overhead used to process SQL error codes?
- FETCH FIRST ROW ONLY in an update query?
- Possibilities of deadlock
- Deleting N rows from a DB2 table
- Changing the primary key
- Impact on applications of migration from V7 to V8
- Concurrent jobs abending with -803
- Can a plan exist without a package?
- Resolving the -927 error
- The number of seconds since 1970
- Getting what is in table A, but not in table B
- Removing variable length row indicators
- Using LOCKSIZE TABLE for performance
- Recompile after reorg?


Amicalement,

DB2usa.