DB2 manager status and get snapshot for dbm

DB2 get snaphshot for dbm displays the database manage level information. Scanning the information available, you’ll notice instance monitor switches . I use the Database manager status value to get the status . If no value is returned , then I assume the instance is unavailable. Author: Jack Vamvas(http://www.dba-db2.com) Read more →

Reorg table DB2

Reorg table DB2 Step 1 run reorgchk: ------CODE START--------------- db2 reorgchk update statistics on table all > output.out ------CODE END------------------ Running the command this way will run across all tables rather than RUNSTATS across every table. The reorgchk update statistics report has two sections; the first section is the table information and the second section is the indexes. If there's an asterisk in the last column a reorganization is needed. To reorganize the tables with an asterisk in the last column: -------CODE START---------------- db2 reorg table table_name -------CODE END------------------ where table_name is the name of the table to be reorganized;... Read more →

Windows Server Uptime and Net Statistics Server

How can I find the Windows Server uptime and the last time a Windows Server restarted? Windows Server Uptime and the last time a Windows Server restarted , on a database server is useful information. As well as SQL Server I do also manage some DB2 Server on Windows - which has different information available for server level information. Net Statistics Server displays the details. Normally, I’m only interested in the database server service restart. But if the database server has been down – and the server restarted – it assists in troubleshooting. Yesterday I saw the backups failed –... Read more →

DB2 software requirements gathering for a new server

DB2 software requirements gathering for a new server is important for planning a DB2 server deployment. I use this DB2 software requirements gathering template to elicit requirements. The template is designed to record and maintain the initial consultation. It is important for me , to keep this stage smooth and stress-free. By working through a checklist – both I and the requestor establish a starting point. Once the information is gathered , I present this to the wider DBA team – and depending the details and analysis process occurs. This could lead to further meetings with the requestor – drilling-down... Read more →

Create a DDL on an existing DB2 table

The following code will create a DDL of an existing table . If you don't need to create an output file omit the use of the -o option db2look -d MY_DB -a -e -x -o MY_FILE.sql Read More Deciding to reorg DB2 tables with overflow value Commands to check for read only Linux file system SQL Parser Compare DDL of 2 databases in DB2 Linux top greater than 100 percent - CPU Read more →