DB2 SORTHEAP and pinned pages

This post discusses SORTHEAP DB2 and pinned pages Information message in db2diag.log FUNCTION: DB2 UDB, buffer pool services, sqlbKeepPagesPinned, probe:20 MESSAGE : ADM6071I The maximum number of pinned pages allowed concurrently was reached in buffer pool "MYBUF8K" (ID "2"). As a result performance may not be optimal. Increasing the SORTHEAP database configuration parameter may reduce the chances of this condition occurring in the future. Notes 1) The message refers to the sqlbKeepPagesPinned function. 2) The message indicates the specified buffer pool is too small for current activity. 3) This also points to high CPU usage 4) Recommend index analysis focusing... Read more →

DB2 Incremental Restore

A DB2 Incremental Restore recovery strategy requires: a) The full backup image b) 0 or more incremental backup c) The days logs The db2ckrst utility parses the history file and allows you to source the relevant backup images. Method 1 - Automatic Restore of Incremental Backup db2 RESTORE DB MYDB INCREMENTAL AUTOMATIC TAKEN AT The INCREMENTAL AUTOMATIC , attempts the restore automatically. Based on the history file information. DB2 will manage finding the last backup with a full copy of the tablespaces and then apply subsequent incremental changes. Method 2 - Manual Restore of Incremental backup 1) Mount the... Read more →

DB2 - Real time monitoring of DB2 backup and restore

A useful command for DB2 DBAs is the LIST UTILITIES command. It displays the list of active utilities. Examples of usage include : BACKUPS, RESTORES, performance issue, progress of RUNSTATS [db2usr1@server1 ~]$ db2 list utilities show detail ID = 36708 Type = BACKUP Database Name = MYDB Partition Number = 0 Description = offline db Start Time = 18/02/2012 10:29:57.616567 State = Executing Invocation Type = User Throttling: Priority = Unthrottled Progress Monitoring: Estimated Percentage Complete = 99 Total Work = 124309084 bytes Completed Work = 123348784 bytes Start Time = 18/02/2012 10:29:57.616576 See Also Command to see connection on... Read more →

DB2 – verify DB2 is available

This article describes some methods of checking DB2 is running on a Linux Server Method 1 Log onto the server and execute db2start as the instance owner. If the instance is running you’ll see , something like: 02/10/2012 23:36:14 0 0 SQL1026N The database manager is already active. SQL1026N The database manager is already active. Method 2 Log onto the server a run a netstat –a. This lists all TCP/IP connections. Look for the instance names or the ports , such as : tcp 0 0 *:db2c_db2a *:* LISTEN tcp 0 0 *:db2c_db2b *:* LISTEN tcp 0 0 *:db2c_db2c *:*... Read more →

DB2 – error messages

You can look up any error message from the command line with "db2 ? sqlxxxx" (where xxxx is the SQLCODE with no sign and leading 0 to make it 4 digits long) You can also use db2 “? SQLxxxx” | more The Linux command – more – allows paging of text one screen at a time An example DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031, DRIVER=3.53.70 db2 ? SQL805 Returned SQL0805N Package "" was not found. With an in-depth explanation and User Response See Also DB2 error tips Read more →