How to check DB2 Status

pada level OS bisa dicek dengan command:
$ ps -ef |grep db2

pada DB2 prompt:
$ db2 connect to bcudb user bcuaix using passwd
Database Connection Information
Database server = DB2/AIX64 9.5.1
SQL authorization ID = BCUAIX
Local database alias = BCUDB


$ db2 get connection state
Database Connection State
Connection state = Connectable and Connected
Connection mode = SHARE
Local database alias = BCUDB
Database name = BCUDB
Hostname =
Service name =

$ db2 list active databases
Active Databases
Database name = BCUDB
Applications connected currently = 14
Database path = /db2home/bcuaix/bcuaix/NODE0000/SQL00001/

$ db2 list applications

Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
——– ————– ———- ————————————————————– ——– —–
BCUAIX java 45651 10.22.133.32.37272.100623114444 BCUDB 1
BCUAIX java 45650 10.22.133.32.37274.100623114446 BCUDB 1
BCUAIX Toad.exe 45663 10.22.151.142.14346.10062311522 BCUDB 1
BCUAIX java 45656 10.22.133.32.37298.100623114800 BCUDB 3
BCUAIX java 45649 10.22.133.32.37271.100623114443 BCUDB 1
BCUAIX db2bp 45674 10.22.133.27.64461.100623115714 BCUDB 3
BCUAIX java 45654 10.22.133.32.37276.100623114447 BCUDB 1
BCUAIX java 45647 10.22.133.32.37273.100623114445 BCUDB 1
BCUAIX BIBusTKServerM 45660 10.22.133.32.37319.100623114858 BCUDB 1
BCUAIX javaw.exe 45673 10.22.151.155.55816.10062311575 BCUDB 1
BCUAIX java 45653 10.22.133.32.37278.100623114455 BCUDB 1
BCUAIX db2bp.exe 45672 10.22.151.155.55560.10062311575 BCUDB 1
BCUAIX java 45652 10.22.133.32.37277.100623114453 BCUDB 1

$ db2 list utilities show detail

ID = 5841
Type = LOAD
Database Name = BCUDB
Partition Number = 0
Description = ONLINE LOAD DEL AUTOMATIC INDEXING INSERT NON-RECOVERABLE DM_1 .VOICE_SU_FACTS
Start Time = 06/23/2010 18:59:40.314568
State = Executing
Invocation Type = User
Progress Monitoring:
Description = SETUP
Completed Work = 0 bytes
Start Time = 06/23/2010 18:59:40.314572

reference: http://www.dbforums.com/3809242-post2.html

Advertisements

About davidand

Hi, welcome to my blogs. My name is David Andriansyah. I am currently working as an independent Cognos Business Intelligence consultant, and I also as Freelance Web Developer. View all posts by davidand

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: