November 2018
M T W T F S S
« Oct    
 1234
567891011
12131415161718
19202122232425
2627282930  

Categories

WordPress Quotes

A real decision is measured by the fact that you've taken a new action. If there's no action, you haven't truly decided.
Tony Robbins

Recent Comments

November 2018
M T W T F S S
« Oct    
 1234
567891011
12131415161718
19202122232425
2627282930  

Short Cuts

2012 SERVER (64)
2016 windows (9)
AIX (13)
Amazon (34)
Ansibile (18)
Apache (133)
Asterisk (2)
cassandra (2)
Centos (209)
Centos RHEL 7 (258)
chef (3)
cloud (2)
cluster (3)
Coherence (1)
DB2 (5)
DISK (25)
DNS (9)
Docker (28)
Eassy (11)
ELKS (1)
EXCHANGE (3)
Fedora (6)
ftp (5)
GIT (3)
GOD (2)
Grub (1)
Hacking (10)
Hadoop (6)
horoscope (23)
Hyper-V (10)
IIS (15)
IPTABLES (15)
JAVA (7)
JBOSS (32)
jenkins (1)
Kubernetes (2)
Ldap (5)
Linux (189)
Linux Commands (167)
Load balancer (5)
mariadb (14)
Mongodb (4)
MQ Server (22)
MYSQL (84)
Nagios (5)
NaturalOil (13)
Nginx (30)
Ngix (1)
openldap (1)
Openstack (6)
Oracle (34)
Perl (3)
Postfix (19)
Postgresql (1)
PowerShell (2)
Python (3)
qmail (36)
Redis (12)
RHCE (28)
SCALEIO (1)
Security on Centos (29)
SFTP (1)
Shell (64)
Solaris (58)
Sql Server 2012 (4)
squid (3)
SSH (10)
SSL (14)
Storage (1)
swap (3)
TIPS on Linux (28)
tomcat (60)
Uncategorized (29)
Veritas (2)
vfabric (1)
VMware (28)
Weblogic (38)
Websphere (71)
Windows (19)
Windows Software (2)
wordpress (1)
ZIMBRA (17)

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

Who's Online

24 visitors online now
7 guests, 17 bots, 0 members

Hit Counter provided by dental implants orange county

Errors SQL22212N or DBA1177N with DB2 Control Center

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 Catalog Database.

Resolving the problem

Resolving this issue can be as easy as restarting the DAS. If that doesn’t work then check the DAS configuration and if needed, create the Tools Database.

1. RESTART THE DAS:
The most common solution is to simply restart the DB2 Administration Server (DAS) 
Log in as the DAS owner and perform these commands to stop and start the DAS:

db2admin stop 
db2admin start

2. CHECK DAS CONFIGURATION: 
If the errors persist, check the following DB2 Administration Server configuration settings: 

      TOOLSCAT_DB 

 

      TOOLSCAT_INST 

 

    TOOLSCAT_SCHEMA

These settings can be viewed with the command: GET ADMIN CONFIGURATION 

For example: 
log on as an instance owner (db2inst1) and use this command: 
db2 get admin cfg

       

 

       

OUTPUT:

       

Tools Catalog Database (TOOLSCAT_DB) = 
Tools Catalog Database Instance (TOOLSCAT_INST) = 
Tools Catalog Database Schema (TOOLSCAT_SCHEMA) =

3. CREATE TOOLSDB: 
If the output from the ‘get admin cfg’ command is empty as listed above, then you will need to create the Tools Catalog Database. 

For Example: 
log on as an instance owner (db2inst1) and use these commands: 
db2 create tools catalog SYSTOOLS create new database TOOLSDB

       

db2 get admin cfg

       

OUTPUT:

       

Tools Catalog Database (TOOLSCAT_DB) = TOOLSDB

       

Tools Catalog Database Instance (TOOLSCAT_INST) = DB2INST1

       

Tools Catalog Database Schema (TOOLSCAT_SCHEMA) = SYSTOOLS

       

Note: The DB2 Administration Server configuration keywords are initially set when the TOOLSDB database is created as listed above. The settings are removed if the DAS instance is dropped. Thus if you drop the DB2 Administration Server and already have a tools database created, remember to update the admin config settings with the name of the tools database using the ‘db2 update admin config’ command.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

  

  

  

Blue Captcha Image
Refresh

*

Protected by WP Anti Spam