DB2 session information

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Francesco
    #1

    DB2 session information

    Hi all.

    I would want to know all the informations about my open work sessions (as sysmaster.sysse ssions of Informix).
    How can I found these informations ?

    Thanks a lot.
    Francesco
    Tags: None
    • Blair Adamache
      #2
      Re: DB2 session information

      Have a look at all these special registers in the SQL Reference:

      CLIENT ACCTNG
      CLIENT APPLNAME
      CLIENT USERID
      CLIENT WRKSTNNAME
      CURRENT DBPARTITIONNUM
      CURRENT PATH
      CURRENT SCHEMA
      CURRENT SERVER
      CURRENT TIME
      CURRENT TIMESTAMP
      CURRENT TIMEZONE
      CURRENT USER
      SESSION USER
      SYSTEM USER
      USER

      Francesco wrote:[color=blue]
      > Hi all.
      >
      > I would want to know all the informations about my open work sessions
      > (as sysmaster.sysse ssions of Informix).
      > How can I found these informations ?
      >
      > Thanks a lot.
      > Francesco[/color]

        Comment

        • Francesco
          #3
          Re: DB2 session information

          Thanks for your help, but where can I download the correct SQL reference for
          DB2 ?
          Doesn't exist a specific command that send to me some informations about
          user sessions ?

          Still thanks.
          Francesco


          "Blair Adamache" <badamache@2muc hspam.yahoo.com > ha scritto nel messaggio
          news:c8iisj$8bt $1@hanover.toro lab.ibm.com...[color=blue]
          > Have a look at all these special registers in the SQL Reference:
          >
          > CLIENT ACCTNG
          > CLIENT APPLNAME
          > CLIENT USERID
          > CLIENT WRKSTNNAME
          > CURRENT DBPARTITIONNUM
          > CURRENT PATH
          > CURRENT SCHEMA
          > CURRENT SERVER
          > CURRENT TIME
          > CURRENT TIMESTAMP
          > CURRENT TIMEZONE
          > CURRENT USER
          > SESSION USER
          > SYSTEM USER
          > USER
          >
          > Francesco wrote:[color=green]
          > > Hi all.
          > >
          > > I would want to know all the informations about my open work sessions
          > > (as sysmaster.sysse ssions of Informix).
          > > How can I found these informations ?
          > >
          > > Thanks a lot.
          > > Francesco[/color]
          >[/color]


            Comment

            • Serge Rielau
              #4
              Re: DB2 session information

              You can encapsulate them into a view if you wish....
              I must be missing something.


              --
              Serge Rielau
              DB2 SQL Compiler Development
              IBM Toronto Lab

                Comment

                • Blair Adamache
                  #5
                  Re: DB2 session information

                  Volume 1 and Volume 2 of the SQL Reference are in PDF format here for
                  your downloading pleasure:

                  http://www-306.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main


                  Francesco wrote:
                  [color=blue]
                  > Thanks for your help, but where can I download the correct SQL reference for
                  > DB2 ?
                  > Doesn't exist a specific command that send to me some informations about
                  > user sessions ?
                  >
                  > Still thanks.
                  > Francesco
                  >
                  >
                  > "Blair Adamache" <badamache@2muc hspam.yahoo.com > ha scritto nel messaggio
                  > news:c8iisj$8bt $1@hanover.toro lab.ibm.com...
                  >[color=green]
                  >>Have a look at all these special registers in the SQL Reference:
                  >>
                  >>CLIENT ACCTNG
                  >>CLIENT APPLNAME
                  >>CLIENT USERID
                  >>CLIENT WRKSTNNAME
                  >>CURRENT DBPARTITIONNUM
                  >>CURRENT PATH
                  >>CURRENT SCHEMA
                  >>CURRENT SERVER
                  >>CURRENT TIME
                  >>CURRENT TIMESTAMP
                  >>CURRENT TIMEZONE
                  >>CURRENT USER
                  >>SESSION USER
                  >>SYSTEM USER
                  >>USER
                  >>
                  >>Francesco wrote:
                  >>[color=darkred]
                  >>>Hi all.
                  >>>
                  >>>I would want to know all the informations about my open work sessions
                  >>>(as sysmaster.sysse ssions of Informix).
                  >>>How can I found these informations ?
                  >>>
                  >>>Thanks a lot.
                  >>>Francesco[/color]
                  >>[/color]
                  >
                  >[/color]

                    Comment

                    Previous template Next
                    Working...