August 2018
M T W T F S S
« Jul    
 12345
6789101112
13141516171819
20212223242526
2728293031  

Categories

WordPress Quotes

Instead of worrying about what people say of you, why not spend time trying to accomplish something they will admire.
Dale Carnegie

Recent Comments

August 2018
M T W T F S S
« Jul    
 12345
6789101112
13141516171819
20212223242526
2728293031  

Short Cuts

2012 SERVER (64)
2016 windows (9)
AIX (13)
Amazon (31)
Ansibile (18)
Apache (128)
Asterisk (2)
cassandra (2)
Centos (208)
Centos RHEL 7 (256)
chef (3)
cloud (2)
cluster (3)
Coherence (1)
DB2 (5)
DISK (25)
DNS (9)
Docker (24)
Eassy (11)
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 (6)
JBOSS (32)
jenkins (1)
Kubernetes (2)
Ldap (5)
Linux (189)
Linux Commands (167)
Load balancer (5)
mariadb (14)
Mongodb (4)
MQ Server (21)
MYSQL (82)
Nagios (5)
NaturalOil (13)
Nginx (29)
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 (59)
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

32 visitors online now
1 guests, 31 bots, 0 members

Hit Counter provided by dental implants orange county

DB2 Basics

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” [edit]How to check DB2 licence /export/home/ldapdb2/sqllib/adm/db2licm -l [edit]How to get the DB2 version db2level [edit]How to make sure DB2 starts and works with WAS […]

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 […]

DB2 Commands

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

[…]

Starting the DB2 control center on Linux

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.

db2 tcp ip bindings

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 […]