Planet DB2
  • About
  • Submit Your Blog
  • Contact Us
Select Page

What Type of Changes Cause Db2 Packages to Get Invalidated?

by Craig S. Mullins | Aug 30, 2021 | change management, packages, REBIND

Db2 DBAs are constantly working with database objects such as Databases, Tablespaces, Tables, and Indexes. And many requirements cause DBAs to have to modify these objects. Some modifications may be simple, such as just issuing an ALTER statement. Others may be more...

Db2 12 for z/OS Function Level 510

by Craig S. Mullins | Jun 15, 2021 | FL510, Function Level, migration, packages

I'm a little late with this Db2 function level update, but better late than never, right?In April 2021, IBM introduced a new function level, FL510, for Db2 12 for z/OS. If you want to take a look at the announcement for it, you can read it here, but...

DB2 Handling -805 on SYSLH2 packages

by Cristian Molaro | Aug 7, 2010 | DB2 LUW, DB2 z/OS, packages, sqlcode, sqlstate

Did you ever encounter a SQLCODE -805 (SQLSTATE 51002) in a distributed dynamic SQL environment? A bit strange because the SQLCODE -805 says DBRM or package not found in plan, but we are dealing with dynamic SQL. Here is what happened…It all started with an...

Recent Posts

  • Harnessing the Power of zIIP Processors for Improved Db2 Performance and Lower Cost
  • The DB2Night Show #253: Explain Essentials for Query Optimization
  • A Db2 for z/OS DBA Poem
  • Consider Application-Level Lock Control in Db2 13 for z/OS
  • Choosing the BEST RDBMS

Recent Comments

    Copyright 2020 Planet DB2
    ×

    Submit Your Blog