Errors SQL22212N or DBA1177N with DB2 Control Center
How to get a snapshot for DB2 db2 get snapshot for dynamic sql write to file on dbname | tee output.file or db2 “select * from table( SNAPSHOT_DYN_SQL( ‘dbname’,-1) as t” How to check DB2 licence /export/home/ldapdb2/sqllib/adm/db2licm -l How to get the DB2 version db2level How to make sure DB2 starts and works with WAS […]
Technote (troubleshooting) Problem(Abstract) DBA1177N and SQL22212N occur when attempting to connect to an instance from the DB2 Control Center Cause The DBA1177N message will appear under one of the following conditions: 1. The Tools Catalog Database has not been created.2. The DAS configuration parameters have not been updated.3. The connection failed (SQL22212N) to the Tools […]
Starting the DB2 control center on Linux
Start an instance As an instance owner on the host running db2, issue the following command $ db2start Stopping the instance $ db2stop Connect to the database as instance owner $ db2 as a user of the database: $source ~instance/sqllib/db2cshrc (csh users) $ . ~instance/sqllib/db2profile (sh users) $ db2 connect to databasename Create a table […]
db2 tcp ip bindings
To start the DB2 control center, perform the following steps: Login as root. At the command line, run the following command: xhost +localhost. Run the following command su – ctginst1. Run the following command db2cc.
Enable DB2 service ports for remote connections. To enable outside users to get to your DB2 databases, you’ll need to set up the DB2 service port, as it is not configured by the Synaptic installation process. As the regular user, run sudo vi /etc/services and add this line to the end of the file and […]