Results 1 to 6 of 6
  1. #1
    Join Date
    May 2012
    Posts
    155

    Unanswered: Application ID vs. Agent ID

    Hallo everyone,

    I read about application ID and agent ID. I am confused, if they are the same?

    If I am not mistaken, agent IDs are IDs for all the users available in the OS right?

    Could someone please tell me, how I can list which agent IDs available for a particular database?

    Well, I am not sure if an agent ID and an OS user are the same. Please help.

    Thank you.

    Regards,
    Ratna

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    An application id generally represents a single connection to the database. Each application connection may have one or more agents, for example if a parallel operation is taking place (intra-partition parallel query or utility parallelism).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ratnalein View Post
    I read about application ID and agent ID. I am confused, if they are the same?
    No.
    Quote Originally Posted by ratnalein View Post
    If I am not mistaken, agent IDs are IDs for all the users available in the OS right?
    No.

    Quote Originally Posted by ratnalein View Post
    Could someone please tell me, how I can list which agent IDs available for a particular database?
    Take an application snapshot, for example.
    Quote Originally Posted by ratnalein View Post
    Well, I am not sure if an agent ID and an OS user are the same.
    No, they are not the same.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    May 2012
    Posts
    155
    Hallo Marcus_A and n_i,

    thanks for the replies. Perhaps it is better to understand the users concept first before I go to the application level.

    I would like to know which privileges a user for a particular database has. Example:

    Database SAMPLE has users. Some of them are "db2inst1" and "ratna".
    I would like to know, what privileges the user "ratna" has. For this purpose, I am thinking about using this command:

    GET SNAPSHOT FOR APPLICATION AGENTID appl-handle

    Is this the correct command? I am confused since the term appl-handle is actually not representing a particular user. In fact, it is referencing an application, right?

    Thank you for the comments.

    Regards,
    Ratna

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Most of the authorization info is stored in SYSCAT.DBAUTH and SYSCAT.TABLEAUTH catalog views. There are also some other commands to show it for a particular user or group account. In is not in the snapshot for application.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    May 2012
    Posts
    155
    thank you Marcus_A

Posting Permissions

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