Blog
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  

« i Can … Secure my Telnet Remote Terminal Session | Main | i Can … Retrieve Spool Information »

December 07, 2009

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d83545a5d153ef0120a70f4238970b

Listed below are links to weblogs that reference i Can … Cancel SQL Statements:

Comments

The SQL cancel support has been improved. Customer feedback on the cancel support showed that cancels were allowed to end Native DB I/O operations. The following PTF has been provided to allow cancel users to direct the database whether to allow Record Level Access (RLA) operations to be canceled.

IBM i 6.1 PTF SI41025
IBM i 7.1 PTF SI41151

OSP-DB Add QIBM_SQL_NO_RLA_CANCEL environment variable


DESCRIPTION OF PROBLEM :
------------------------
The SQL Cancel support includes logic to insure that DB2 for i programs are active on the stack of the initial thread in the target job for the cancel request. Applications which utilize
Native DB I/O can observe cases where the cancel request is processed and a record level access operation ends with MSGCPF5257 followed by MSGCPF9999.

CORRECTION:
-----------
An environment variable can be used by the customer to direct DB2 for i to avoid canceling RLA access operations. Upon the first cancel request for a specific job, the environment variable QIBM_SQL_NO_RLA_CANCEL will be accessed. If the environment variable exists, the cancel request will not be
honored when RLA is the only database work on-going within the initial thread at the time the cancel request is received.

The environment variable is SQL Cancel operational switch. The variable can be created at the job or system level. Creating it once at the system level will affect how SQL Cancel's are processed for all jobs.

ADDENVVAR ENVVAR(QIBM_SQL_NO_RLA_CANCEL)

or

ADDENVVAR ENVVAR(QIBM_SQL_NO_RLA_CANCEL) LEVEL(*SYS)


Regards,
Scott Forstie
forstie@us.ibm.com

Verify your Comment

Previewing your Comment

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

Working...
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.

Working...

Post a comment

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