One of the most painful experiences in the work life of a database administrator (DBA) is probably the accidental drop of a database object on a production subsystem. Most IT shops have procedures to prevent this occurrence, yet it still happens.
What’s the main difference between single-row and multi-row inserts? Simply the performance. If you are inserting many rows in a loop via a single-row insert, you call DB2 for every single row, which means you spend some time for the communication with the DB2.
CA Technologies DB2 User Day: CA experts will update you on mainframe trends, the latest developments in CA Database Management, a look into the future of CA products and insight into how your peers have solved real problems with CA Technologies Solutions for DB2. Sign up for this FREE event.