Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Location
    Barcelona
    Posts
    32

    Question Unanswered: who is connected

    is there anyway to know how much people is logged in a server (AS400)? I need extract this information from some system table or system view.

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186

    Surely not stored in a table.

    Hi,
    Buffer pool monitoring and tuning requires thorough analysis of both tablespace and buffer pool.
    Since the DB2 Control Center does not provide buffer pool snapshots,
    you must take buffer pool snapshots by using the command line interface or a vendor tool. I think there are few available.
    Snapshot data is in db2's internal memory.
    It is available through various apis as well as db2 get snapshot command only.
    So better get it through the command. I hope you know that.
    db2 get snapshot command (refer the DB2 CLP help).

    -Prashant G Dahalkar
    Prashant

  3. #3
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186

    Not stored in a table

    Hi,
    Buffer pool monitoring and tuning requires thorough analysis of both tablespace and buffer pool.
    Since the DB2 Control Center does not provide buffer pool snapshots,
    you must take buffer pool snapshots by using the command line interface or a vendor tool. I think there are few available.
    Snapshot data is in db2's internal memory.
    It is available through various apis as well as db2 get snapshot command only.
    So better get it through the command. I hope you know that.
    db2 get snapshot command (refer the DB2 CLP help).

    -Prashant G Dahalkar
    Prashant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •