i can

Dawn May

Dawn May

Bookmark and Share

October 2014

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

« IBM Power Systems Technical University – What Happens in Vegas Is for You to Know | Main | Automated Problem Reporting With Service Monitor »

October 26, 2010


TrackBack URL for this entry:

Listed below are links to weblogs that reference Subsystem Configuration for SQL Server Mode Jobs:


What were customers having for issues that necessitated this? I probably do a lot less SQL than other shops because a lot of my coding is RPG native access and I only go to SQL for dynamic result set selection.

Aaron - there are environments where many applications are using SQL and there can be hundreds of QSQSRVR jobs. Prior to this change, it was very difficult to impossible to be able to tie the QSQSRVR jobs back to the application requesting them. This change provides that additional level of management.

On 7.1 is there a way to configure the QSQSRVR jobs being used in conjunction with an HTTP Server. We are doing a lot of web services and the QSQSRVR jobs are getting out of hand.

Hello Greg,
I have an upcoming PTF for 7.1 that should help. PTF SI48797 will ship the following change. Net... apply the PTF and HTTP Server based SQL Server Jobs will show up in the subsystem specified within the QIBM_SRVRMODE_SBS environment variable.
Regards, Scott Forstie

The QIBM_SRVRMODE_SBS environment variable is ignored whenever the name of the application subsystem is 'QHTTPSVR' or 'ZEND'. These two subsystems are used by the IBM DB2 Web Query and the Zend PHP products. Both of these products utilize SQL CLI for accessing DB2 for i databases.

The QIBM_SRVRMODE_SBS environment variable processing has been changed to allow 'QHTTPSVR' and 'ZEND' subsystems to be utilized for QSQSRVR SQL server mode activity.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Comments are moderated, and will not appear until the author has approved them.