Previous Job
DB2 Consultant
Ref No.: 18-00255
Location: Wayne, New York
· DB2 Maintenance utilities like Reorg, Runstats, Image Copy and when to use them
· Other DB2 utilities like Load Resume, Load Replace, Unload
· Concept of table & index partitions – These are for DBA use. For developers, it is useful to know for optimizations and resolve contention issues if they arise.
· DB2 Catalog Tables – These are for DBA use. Developers use it for verification purpose only
· Knowledge on "how to optimize” & improve system throughout – This includes index etc. as described above. Also, there are ways to design & program to improve parallel processing