dba-db2.com - db2 performance tuning, DB2 tuning,db2 performance,sql tuning db2, DBA in DB2, DBA Scripts,DB2,DB2 consulting,DB2 consultant,DB2 architecture,DB2 training

Command to see connection on a DB2 database - list applications

06 January,2011 by Tom Collins

If on the command line use , LIST APPLICATIONS.

If you were using a client such as Putty – logon as relevant user,The logon account must have at least  one of these Authorisations: sysadm,sysctrl,sysmaint,sysmon

 --STEP 1 – connect to relevant database

$db2 connect to <MYDB>

 

--STEP 2

$db2 list applications

 

Author: Rambler(http://www.dba-db2.com)

Share:

Posted by Tom Collins at 9:25 AM in Troubleshooting | Permalink | Comments (2) | TrackBack (0)

Searches: , , , , ,

Very interesting and useful article.. http://remotepccure.com

Posted by: Window support | Jun 2, 2011 11:36:03 PM

Very interesting and useful article..

Posted by: Account Deleted | Jun 2, 2011 11:37:14 PM

Verify your Comment

Previewing your Comment

Posted by: |

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Command to see connection on a DB2 database - list applications

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright