DB2 10 and SMS

SMS stands for System Managed Storage, short for Data Facility Storage Management Subsystem (DFSMS), which is an integral part of z/OS . SMS is composed of a set of components designed to make disk storage management easier and more efficient. SMS has many benefits...

DB2 Handling -805 on SYSLH2 packages

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...