top of page

DB2 Snapshot information | Monitor level : Connections list

  • Writer: Jha Chandan
    Jha Chandan
  • Feb 15, 2021
  • 1 min read

Updated: Feb 16, 2021

In this article we will see and learn how to get snapshot information about databases and instances for monitor level connections list.


1) list applications [show detail] : Application identification information for all applications currently connected to a database that is managed by the DB2(R) instance on the partition where snapshot is taken.


Example:

db2 connect to <db_name>
db2 list applications show details
ree

2) list applications for database dbname[show detail] : Application identification information for each application currently connected to the specified database.

Example:

db2 list applications for database <db_name> show detail
ree

3) list dcs applications: Application identification information for all DCS applications currently connected to a database that is managed by the DB2 instance on the partition where snapshot is taken.


Example:

db2 connect to <db_name>
db2 list dcs applications
ree

In next post we will see DB2 Snapshot information | Monitor level : Database Manager. Please Like, Follow, Share & Subscribe.

Comments


jc_logo.png

Hi, thanks for stopping by!

Welcome to my “Muse & Learn” blog!
Muse a little, learn a lot.✌️

 

Here you’ll find practical SQL queries, troubleshooting tips with fixes, and step-by-step guidance for common database activities. And of course, don’t forget to pause and muse with us along the way. 🙂
 

I share insights on:​​

  • Db2

  • MySQL

  • SQL Server

  • Linux/UNIX/AIX

  • HTML …and more to come!
     

Whether you’re just starting out or looking to sharpen your DBA skills, there’s something here for you.

Let the posts
come to you.

Thanks for submitting!

  • Instagram
  • Facebook
  • X
2020-2025 © TechWithJC

Subscribe to Our Newsletter

Thanks for submitting!

  • Facebook
  • Instagram
  • X

2020-2025 © TechWithJC

bottom of page