what is consistency token

Answers were Sorted based on User's Feedback



what is consistency token..

Answer / guest

Consistency token is a timestamp generated by the
precompiler and passed on to the DBRM and the load module
for synchronization purposes. The program will execute only
when the DBRM and load module contoken matches.

Is This Answer Correct ?    14 Yes 2 No

what is consistency token..

Answer / harsh

Consistency Token is a time stamp.
One can see the token using the following query:
select * from sysibm.syspackage;

The CONTOKEN column gives the consistency token

Is This Answer Correct ?    7 Yes 1 No

what is consistency token..

Answer / vj

The program and its associated SQL package contain a consistency token that is checked when a call is made to the SQL package. The consistency tokens must match or the package cannot be used. It is possible for the program and SQL package to appear to be uncoordinated. Assume the program is on the iSeries system and the application server is another iSeries system. The program is running in session A and it is recreated in session B (where the SQL package is also recreated). The next call to the program in session A might result in a consistency token error. To avoid locating the SQL package on each call, SQL maintains a list of addresses for SQL packages that are used by each session. When session B re-creates the SQL package, the old SQL package is moved to the QRPLOBJ library. The address to the SQL package in session A is still valid. (This situation can be avoided by creating the program and SQL package from the session that is running the program, or by submitting a remote command to delete the old SQL package before creating the program.)

To use the new SQL package, you should end the connection with the remote system. You can either sign off the session and then sign on again, or you can use the interactive SQL (STRSQL) command to issue a DISCONNECT for unprotected network connections or a RELEASE followed by a COMMIT for protected connections. RCLDDMCNV should then be used to end the network connections. Call the program again.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the difference between cursor and select statement?

0 Answers  


is there any restrictions for unions ?

4 Answers   Patni,


what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  


Which transaction use a command thread ?

1 Answers  


what is the soft code for deadlock ?

2 Answers   Logica CMG,






Where would you find information about the type of database authority held by the user?

2 Answers  


What is cursor in dbms?

0 Answers  


What is a thread?

3 Answers  


In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

2 Answers  


Explain the use of the WHERE clause?

1 Answers  


What is subquery ?

6 Answers  


What is the difference between Primary key and unique index?

6 Answers  


Categories