Quest 3.5.2 crashing DB2 9.5

Platform information Informational tokens are DB2 v9.5.0.1, s080328, MI00225, Fix Pack 1. Operating System Information: OSName: Linux NodeName: server1.mydomain.net Version: 2 Release: 6 Machine: x86_64 Received the following message when I tried to initialise HADR and trigger the Remote Catchup on a existing HADR set up .This was due to an unplanned outage. 1)the initial observation was that after a short period of remote catchup the db2 instance would shut down An attempt at connecting would return "Unable to attach to database manager. Please ensure db2start has been run." An interorgation on db2diag.log saw : ADM0503C An unexpected internal processing... Read more →

Generate a key pair with ssh-keygen on Linux

Follow the steps below to generate a key pair with ssh-keygen on Red Hat Linux Replace : myserver1 and myserver2 with your server names #SSH on both members of the cluster – Prepare SSH /usr/bin/ssh-keygen -f /root/.ssh/id_dsa -q -t dsa -N "" /usr/bin/ssh-keygen -f /root/.ssh/id_rsa -q -t rsa -N "" cat /root/.ssh/id_dsa.pub >> /root/.ssh/authorized_keys2 cat /root/.ssh/id_rsa.pub >> /root/.ssh/authorized_keys2 #On Node 1 (UKRHDB2P02)- in other words - ssh myserver1 cat /root/.ssh/authorized_keys2 >> /root/.ssh/authorized_keys2 #On Node 2 (UKASDB2P02)- in other words - ssh myserver2 cat /root/.ssh/authorized_keys2 >> /root/.ssh/authorized_keys2 #test ssh uname -a Ref:Jack Vamvas(http://www.dba-db2.com) Read more →

db2move to copy data between databases

I need to move ddl and data from one database to another . On the same server and instance. The basic idea was going to be : a)using db2move export all ddls and data into a file b)using db2move import the ddls and data STEP 1 --this exports all tables and data, the output files are stored in the current directory , I used /tmp db2move MYDB export --output Application code page not determined, using ANSI codepage 1208 ***** DB2MOVE ***** Action: EXPORT Start time: Fri Jul 9 13:47:29 2010 Connecting to database MYDB ... successful! Server : DB2 Common... Read more →

SQL0286N A default table space could not be found

SQL0286N A default table space could not be found with a page size of at least "4096" that authorization ID "user1" is authorized to use. SQLSTATE=42727 This was after a DECLARE GLOBAL TEMPORARY TABLE type of statement I had a look at the users permissions.They were CREATE SCHEMA user1 ; grant connect on database to user user1; grant ALTERIN,CREATEIN,DROPIN on schema user1 to user user1; The next test step was to create a tablespace for temprary tables and give USE permissions to "user1". This solved the problem CREATE USER TEMPORARY TABLESPACE usr_tbsp MANAGED BY AUTOMATIC --and issue permissions : GRANT... Read more →

Linux useradd not creating password

I've found that executing similar code to the below was not creating the password.As a consequence I needed to run the passwd process separately. $useradd -g db2fadm1 -m db2fenc1 -p mypassword -d /db2inst1/db2fenc1 The -p parameter is designed to pass encrytpted passwords. The following method creates an encrypted password , which can be added to the -p switch. To assign an initial password, use the following steps: Start the command line Python interpreter with the python command. $python displays the following: Python 2.4.3 (#1, Sep 17 2008, 16:07:08) [GCC 4.1.2 20071124 (Red Hat 4.1.2-41)] on linux2 Type "help", "copyright", "credits"... Read more →