Compare DDL of 2 databases in DB2

Question: How can I write a script to compare the structure of DDL in 2 databases? I understand there are tools on the market , but we are a small company and these tools don’t do exactly what we need and we don’t want to spend extra money on customising Answer: Comparing the DDL structures of 2 databases can be completed at a budget level by exporting key system catalogs and applying sdiff –s. You could take the extra step of using a database to store the object information . This would allow a more effective way of storing and... Read more →

How to find the db2 database create date

How can I find the db2 database create date? To find the database creation date execute a query on the syscat.tables. Example: Method 1 select min(create_time) from syscat.tables Method 2 db2 list tables for schema SYSIBM Read More DB2 Database objects overviews - DBA DB2 Move DB2 schema objects to another schema using ADMIN_COPY_SCHEMA DB2 SET CURRENT SCHEMA - DBA DB2 Read more →

DB2 database hangs on db2 connect - use db2pd to troubleshoot

During a DB2 database Physical 2 Virtual (P2V) migration , the systems administrator did not request for the application be shut down. The usual practise for a P2V is to shut down the application and shut down DB2 – then start P2V. This didn’t occur and resulted in a potential corruption. When I restarted the DB2 server instance and attempted a db2 connect – the DB2 database wouldn’t progress with a successful connection. After some db2diag.log investigation and a DB2 instance restart – a message appeared: ADM1532E Crash recovery has failed with SQLCODE "-1042". Roll Forward to a point in... Read more →

Useradd in Linux - Not copying any file from skel directory into it

When creating a new local user on Linux with the useradd and the directory already exists , the following error \ warning message appears: useradd: warning: the home directory already exists. Not copying any file from skel directory into it. If the directory didn’t exist , the Linux useradd process creates the directory and copies the skel files : .kshrc , .bashrc , .bash_profile and .bash_logout files into the user directory. As a DBA it is not unusual to receive a server with directories already in place. In those situations a scripted approach is required to copy the skel files.... Read more →