SQL Web Connect session limits.

Document ID : KB000028822
Last Modified Date : 14/02/2018
Show Technical Document Details

SQL Web-connect is a feature added to CA-IDMS in release 18.5.  It provides for clients who are not licensed for the SQL Option or IDMS/Server to execute a limited number of SQL and Server based transactions.  The limit is two concurrent sessions of each.

There can be some confusion about what precisely constitutes an SQL session and/or an IDMS Server session. Using the following operator commands, it is possible to examine the current level of utilization of the sessions.

For SQL:     DISPLAY PROD,REGISTERED,ID(GT)
For Server:  DISPLAY PROD,REGISTERED,ID(XS)

(Note: the SYSVIEW command REGPROD can also be used for this purpose.)

As an example, if a user runs a dynamic SQL statement in OCF or IDMSBCF, then that is an SQL session but it is not a Server session.  The output of those commands will look like this:

00000294  DISPLAY PROD,REGISTERED,ID(GT)
00000094  IFA111I 05.53.21 PROD DISPLAY 662
00000094  S OWNER            NAME             FEATURE          VERSION  ID
00000094  N CA               IDMS/SQL-OPT     SQL Web Connect  01.00.00 GT
00000294  DISPLAY PROD,REGISTERED,ID(XS)
00000094  IFA110I NO MATCHING PRODUCT EXISTS FOR DISPLAY PROD COMMAND     

Similarly, if a user uses a Java program (for example the JcfDemo application provided with CA-IDMS/Server), and CONNECTs to a database but does not yet run an SQL statement, then that is an example of a Server session but not an SQL session.  The output will look like this:-

00000294  DISPLAY PROD,REGISTERED,ID(GT)
00000094  IFA110I NO MATCHING PRODUCT EXISTS FOR DISPLAY PROD COMMAND 
00000294  DISPLAY PROD,REGISTERED,ID(XS)
00000094  IFA111I 06.00.42 PROD DISPLAY 991
00000094  S OWNER            NAME             FEATURE          VERSION  ID
00000094  N CA               IDMS-Server      SQL Web Connect  01.00.00 XS

If that user then executes an SQL statement, then the work being done by that user then constitutes one of each - both an SQL and a Server session:-

00000294  DISPLAY PROD,REGISTERED,ID(GT)
00000094  IFA111I 06.05.32 PROD DISPLAY 292
00000094  S OWNER            NAME             FEATURE          VERSION  ID
00000094  N CA               IDMS/SQL-OPT     SQL Web Connect  01.00.00 GT
00000294  DISPLAY PROD,REGISTERED,ID(XS)
00000094  IFA111I 06.05.35 PROD DISPLAY 305
00000094  S OWNER            NAME             FEATURE          VERSION  ID
00000094  N CA               IDMS-Server      SQL Web Connect  01.00.00 XS

So, when considering these limits, the question of whether a given utility occupies an SQL or a Server "slot", or one of each, is dependent upon the kind of program being run and also what that program is doing at the time.

SQL Web Connect allows the user to run a maximum of two sessions of SQL and Server *each* across an entire LPAR.

Furthermore, the message received when these limits are exceeded depends on what action is being done at the time.  If it is during a CONNECT attempt, message DC396019 will be returned.  But if it is an actual SQL statement, a DB006056 will be returned.              

For more information about SQL Web Connect, see the CA IDMS System Operations Guide, chapter 19 "SQL Web Connect".