This new edition of DB2,Part 2, covers the version 4.1 and 5 enhancements to DB2 so programmers can take advantage of all the new and improved features that help them the most. It presents the advanced skills needed to become a top senior programmer or programmer/analyst. Specifics covered in the 2nd edition:
How to use stored procedures that move SQL code off of the client and onto the database server to reduce network overhead
How to use dynamic SQL so your programs can generate and execute SQL statements as they run
How data sharing works on the parallel sysplex and other System/390 configurations
How to work with DB2 data, where the data is managed by a DB2 subsystem on a system thats connected over a network
How to process DB2 data in CICS programs
Advanced locking concepts that show how locking and data sharing affect each other and what impact that has on program efficiency
The concepts and practices of DB2 database administration that let the programmer design databases, manage database objectives, and set up a quality assurance environment