User Community for HCL Informix
  • Home
  • Blogs
  • Forum
  • About
  • Contact
  • Resources
  • Events

Easier Client Sessions Tracking

1/25/2018

1 Comment

 
Picture
                                                                                                            Updated: 8/30/18

This feature was introduced in the Informix Technology 12.10.xC10 fixpack release. It allows you to assign a character string to your CSDK or JDBC client session and identify that character string on the database server.  This is useful for environments where same userid runs multiple instances of the same application, and there is a need to distinguish one session from the other. 

This feature is implemented with a new
CLIENT_LABEL environment variable that is set in your CSDK 4.10.xC10 or JDBC 4.10.JC10 client and is detectable on your IDS 12.10.xC10 database instance. 
 
CLIENT_LABEL is set in the application environment and then is viewable on the database side with two methods:  onstat –g env <sesID> and sysmaster:sysenvses. 
 
(Note that SQL ‘SET ENVIRONMENT’ statement will also support CLIENT_LABEL in 12.10.xC11) 

CSDK Example: 

Here we set CLIENT_LABEL to two different strings and execute the same esqlc program. In this example, the session ids are 43 and 201.
Database

    

JDBC example: 

Here we set CLIENT_LABEL to two different strings in the JDBC connection URL and execute the same JDBC program.  In this example, the session ids are 232 and 234. 

Database

    
This is a simple, yet powerful way to more easily track sessions in your environment. 

Jeffrey McMahon
Senior Software Engineer
Connect with me on LinkedIn

Informix is a trademark of IBM Corporation in at least one jurisdiction and is used under license.
1 Comment
the best essays link
9/30/2019 07:54:50 am

Sales is one of the hardest fields in all of marketing. If you ask me, being a sales agent is really tiring. Every month I need to meet my quotas or else I would not get paid. It is hard to attract customers nowadays, especially when you can buy almost anything on the internet. I really wish that I can keep my job, my family cannot survive without me. This is all that I got right now, I need to make it work.

Reply



Leave a Reply.

    Archives

    November 2019
    September 2019
    May 2019
    April 2019
    February 2019
    January 2019
    October 2018
    July 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

    Categories

    All
    Business
    Technical

    RSS Feed

Proudly powered by Weebly
  • Home
  • Blogs
  • Forum
  • About
  • Contact
  • Resources
  • Events