Move DB2 schema objects to another schema using ADMIN_COPY_SCHEMA

Question: How can I move DB2 objects from one schema to another schema in the same database? When I migrated a database to a new DB2 instance with new logon , I couldn’t access the tables. Answer: What you would really like to do is rename the schema. The ADMIN_COPY_SCHEMA stored procedure manages the process. Under the covers , ADMIN_COPY_SCHEMA is actually copying the objects to the other schema , rather than just renaming the schema. This test example, illustrates the basic steps. There are other more advanced options, check documentation for more details. Read the DB2 user manual for... Read more →

Changing DB2 database pagesize

Question: Analysing an application stack trace , I noticed references to the database pagesize. What is the DB2 database pagesize and how can I change the pagesize value? Answer: It is possible you may be experiencing pagesize issue. But rather than focusing on the DB2 database pagesize focus on the tablespace pagesizes. The DB2 database pagesize parameter contains the value that was used as the default page size when the database was created. Possible values are: 4 096, 8 192, 16 384 and 32 768. When a buffer pool or table space is created in that database, the same default... Read more →

ADM5500W DB2 is performing lock escalation

ADM5500W DB2 is performing lock escalation. The total number of locks currently held is "817", and the target number of locks to hold is "408". How can I resolve? Check the current LOCKLIST level with : db2 get db cfg for COMMDB | grep 'LOCKLIST' Increase the database locklist size to 4096 pages. If the ADM5500W error message continues , double locklist i.e 8192 You can also adjust the locklist percentage used by one application with adjusting the MAXLOCKS What happens if DB2 locklist is out of space for holding locks? Locks are escalated to table level db2 connect to... Read more →