Book DescriptionThis 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
Customer Reviews
Average Rating:
Rating: - DB2 for the COBOL Programmer, Part 2, 2nd Ed.
-excelent part about DB2 working in sysples, locking mechanism
-excelent part about stored procedures
-good introduction to database administration
Rating: - Want to advance your DB2/SQL skills? A "MUST HAVE"!
Buy this book!!! Some computer books are written by computer geeks who know their technical stuff cold. They can't teach worth a darn, but they are deep technical wizards who are highly versed in techno-babble. The worst part of it usually is, they aren't even aware when they are babbling their techno-nonsense!!! The people who wrote the Murach series are NOT (let me repeat, the Murach folks are NOT) such people. It was the most amazing experience to have read ... Read More
Rating: - An excellent choice. You get MORE than your money's worth!
Buy this book!!! Some computer books are written by computer geeks who know their technical stuff cold. They can't teach worth a darn, but they are deep technical wizards highly versed in techno-babble. The people who wrote the Murach series are NOT (let me repeat, the Murach folks are NOT) such people. It was the most amazing experience to have read this book, and to have the feeling that either Curtis Garvin or Anne Prince were looking directly over one's shoulder anticipating the various questions ... Read More
Rating: - DB2 for the COBOL Programmer
I started a new job and needed to learn DB2 in a hurry. I bought part 1 and part 2. I was coding in no time. But the best part is they make excellent reference books because they are laid out so well. These books are well worth the investment.
Rating: - Advanced Topics in DB2
This readable volume covers DB2 data sharing, stored procedures, DB2/CICS interface, DB2 database objects, and the SQL EXPLAIN. Model programs and JCL can be downloaded from the web. I look forward to an instructor's guide (hint to Murach) as they have for other publications.