DB2 Version 9.7 Documentation

I work with SQL Server and DB2 , both have their advantages and disadvantages. But one thing that IBM does more effectively is documentation. SQL Server Books Online is thorough documentation , but the documentation for IBM DB2 is execllent in the way it covers all the details ,in an expansive manner. To give you and idea I've included the list of downloadable PDFs , which can be downloaded from DB2 9.7 documentation The full list of subjects covered Getting started What's New for DB2 Version 9.7 Quick Start Guide - DB2 Personal Edition1 Quick Start Guide - DB2 Servers1... Read more →

DB2 - SQL1051N while Redirected Restore

You’ll get this error message when attempting to restore a database with automatic storage onto a server where the path doesn’t exist I had this problem when attempting : db2 restore db db1 from /db2inst1/backups into db1 redirect without prompting The error message was SQL1051N The path "/db2inst/files" does not exist. SQLSTATE=57019 The resolution was : 1)Create path where the automatic storage should install 2)use the following syntax : db2 "restore db db1 from /db2inst1/backups ON /db2inst1/files/db1 into db1 redirect without prompting" db2 “restore db db1 continue” Source:Jack Vamvas(http://www.dba-db2.com) Read more →

DB2 logging factors and mincommit

Despite choosing logging option (either Circular logging or retain) – every “standard” data and index change is made to the log buffer. The log buffer is then written to disk by the logger process. In the situation of COMMIT the query processing has to wait for the data to be written to disk – this is a potential performance factor The process is based on maximum throughput , and on analysis you can see that most of the time will be spent on the COMMIT phase and related I\O delays . This is compounded in an OLTP process – characterised... Read more →

DB2 Database Administration Server (DAS) Notes

DB2 tools require an instance that is independent of all other instances , but works with all the other instances is the main reason for DAS Only one DAS instance per server A global level profile registry DB2ADMINSERVER contains the DAS instance name. To view the variable value use db2set –all DAS runs as a background process – and restarts automatically on reboot. To manage a DB2 server remotely DAS server must be running. DAS server provides remote clients with relevant information to connect Server administration from a remote client requires requires the user to have SYSADM authority for the... Read more →

DB2 Used Space and REORG

I have the thresholds set at 95% for tablespace used . When the threshold is met a message is triggered like : USERSPACE1 in MYDB has 95 pct used. Instance: db2inst1 First Occurrence: Tue Feb 01 15:29:58 2011 Last Occurrence: Tue Feb 01 15:29:58 2011 Email client: smtp1.myprod.net There is minimal INSERT,UPDATE,DELETE activity in this database , therefore I would commit a REORG and RUNSTATS via a shell script. On most occasions this action will decrease the space used. Note: this script runs usually once a week – but it had not run for a couple of weeks , due... Read more →