Results 1 to 5 of 5

Thread: Sysprocesses

  1. #1
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253

    Unanswered: Sysprocesses

    What would the equivalent be in DB2 to the SQL Server SYSPROCESSES table?

    I just want to see what connections are out there.

    Thank You....
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Sysprocesses

    Originally posted by ansonee
    What would the equivalent be in DB2 to the SQL Server SYSPROCESSES table?

    I just want to see what connections are out there.

    Thank You....
    list applications show detail

  3. #3
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253
    Rock...!

    Thank You...one problem though:

    I'm trying to wexecute this command:
    LIST APPLICATIONS FOR DB AIMI SHOW DETAILS

    Get this error in return:
    SQL1428N The application is already attached to "DB2" while the
    command issued requires an attachment to "NDE1DFE3" for
    successful execution.

    I'm attached to the right database...I don't get it. If I run that command and I'm NOT attached to the database, I get the same error.

    If I don't use the FOR DB portion, I just get info about my local instance.

    Any ideas?
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  4. #4
    Join Date
    Sep 2002
    Posts
    456
    I believe you need to attached to the right "instance" not "database". The command

    db2 list applications

    does not need connectivity to the database.

    Use

    db2 attach to NDE1DFE3

    command and then reissue the list applications command.

    Hope this helps.

    dollar
    Originally posted by ansonee
    Rock...!

    Thank You...one problem though:

    I'm trying to wexecute this command:
    LIST APPLICATIONS FOR DB AIMI SHOW DETAILS

    Get this error in return:
    SQL1428N The application is already attached to "DB2" while the
    command issued requires an attachment to "NDE1DFE3" for
    successful execution.

    I'm attached to the right database...I don't get it. If I run that command and I'm NOT attached to the database, I get the same error.

    If I don't use the FOR DB portion, I just get info about my local instance.

    Any ideas?

  5. #5
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253
    Very cool....thank you!!!
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

Posting Permissions

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