473,387 Members | 1,592 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

DB2 session information

Hi all.

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

Thanks a lot.
Francesco
Nov 12 '05 #1
4 8482
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:
Hi all.

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

Thanks a lot.
Francesco


Nov 12 '05 #2
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" <ba*******@2muchspam.yahoo.com> ha scritto nel messaggio
news:c8**********@hanover.torolab.ibm.com...
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:
Hi all.

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

Thanks a lot.
Francesco

Nov 12 '05 #3
You can encapsulate them into a view if you wish....
I must be missing something.
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #4
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/db2ww...bs.d2w/en_main

Francesco wrote:
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" <ba*******@2muchspam.yahoo.com> ha scritto nel messaggio
news:c8**********@hanover.torolab.ibm.com...
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:
Hi all.

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

Thanks a lot.
Francesco



Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Timin Uram | last post by:
Hey! Is there some sort of limit on how much one could store in a session as far as amount of data? Is it advisable to store a LOT of data in the session when a user logs in to save queries to...
3
by: Microsoft | last post by:
I am using Session variables in my ASP application. I have tested the application on a Win2k professional and it works fine. When the same web app is installed on a win2k advanced server from the...
2
by: Amit D.Shinde | last post by:
Hello Experts.. I need some help regarding cookies and session objects and also global.asa file I am creating one cookie when a user logs in on my website. The cookie stores the login name of...
1
by: Scott Wickham | last post by:
I'm having a problem saving session information on one form and retrieving it on a subsequent form...for only one out of a number of users. Actually, I'm not absolutely certain it's a session...
5
by: Michelle A. | last post by:
I have a four page form. Pages 1-3 stores there information in a session variables. Page four is reached (a final review page) and then the information will be written to the SQL server. When...
0
by: Michael | last post by:
I have a problem here that only seems to happen on the one new server that we are migrating our ASP.Net application to. The server is a Windows 2000 SP4 box. It initially had the .Net Framework...
9
by: RA | last post by:
Hi Please review and let me know if I am correct: 1) My understanding from reading http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/ diforwc-ch05.asp is that...
2
by: Boban Dragojlovic | last post by:
I'm building a complex web-based reservations system. Gathering the user's data requires between 8 and 15 pages (depending on which options they are interested in). I use the "Session" object to...
2
by: lookee | last post by:
Hello all, I have simple PHP application that on one page strarts session and write some information to it. On another page program tryes to fetch information from a third page using cURL. On that...
4
by: Nick Gilbert | last post by:
Hi, Is it possible to access the Session of an arbitary user from an aspx page? On an e-commerce site, I am notified of payment success via a callback from the payment server to an ASPX page...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.