ISeries Data Source Lock

Question

I have a data source configured on my AS400 (iSeries), and when Cognos accesses it through the ODBC client driver, it blocks files on the AS400. Even if the report closes, the files remain locked for a while. This causes problems with updating the data source, reorganizing files, cleaning records, etc. There must be a way to get the ODBC driver to remove the lock while retrieving the data ... or at least keep track of the time it is holding. Any direction would be greatly appreciated.

Thank.

Cognos 10.1.0 .... iSeries V7R1M0

Buck, Thanks for taking the time to comment .... however, I assure you that the iSeries actually works with V7R1M0, and I never said that I have a write lock. I said that the file remains locked. I am sure my question is a specific scenario in which Cognos accesses AS400 files through the ODBC Client Access driver and locks the file. Then holds the lock for a certain time. My question was if there is a way to stop Cognos from saving this file lock. I can provide error messages for accidentally accessing files on iSeries after this lock occurred, but since I was looking for a way to unlock it before these errors occurred, I did not see its relevance ... but I'm sure I would get error CPF3203, telling me that she cannot select the object.

Answer 1

IBM i 7.1 does not work on AS / 400 or iSeries hardware. This is not a semantic thread: Internet searches for ODBC and AS400 will return ancient and unrealizable results.

The question does not include a specific error message, as well as a specific scenario for this error to occur. I assume that you are seeing an object lock (not a write lock) on CLRPFM. If so, the main reason is that the database manager does not completely close the cursors; it gently closes them (sometimes called pseudo close) for performance reasons.

-SQL-, (, SAVOBJ, CLRPFM, DLTF, RGZPFM ..), ALCOBJ , . ALCOBJ OBJ((SOMSCHEMA/SOMETABLE *FILE *EXCL)) WAIT(1) CONFLICT(*RQSRLS)

, , , IBM i, , .

:

ODBC, RPG, , , . - , - SHRRD ( ). - , - * SHRUPD ( ). , IBM i.

; Cognos- SHRUPD , RPG , , . .

, , , (* EXCL) . CLRPFM, RGZPFM, SAVOBJ. Cognos * SHRUPD (WRKOBJLCK ), , CLRPFM, * EXCL CPF3203 - .

, , - . ODBC :

• ODBC connect
• ODBC

DB2 , "close cursor" * SHRUPD. , DB2 -, , Cognos (, , ). - EXCL , Cognos ? , , CLRPFM . , CPF3203.

( Cognos, !), DB2, , , CLRPFM. ALCOBJ CONFLICT (* RQSRLS) - , . CL, CLRPFM. - SQL . 7.1 SQL CL-, CLRPFM TEMPFILE RUNSQL " tempfile" - SQL, * EXCL .

EDIT: RGZPFM

, RGZPFM . : " ", . , . , , . : , , "". , , . ; .

, DELETE , . - , RGZPFM. RGZPFM - , CPYF. RGZPFM ( ) . , " ".

2014, , . - , CREATE TABLE, , RGZPFM. - RGZPFM, - . SQL SELECT, , . , ; , , , DELETE. , goot.