Interested to Buy Any Domain ? << Click Here >> for more details...
what is consistency token
- 3 Answers
- 19613 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is a storage group (stogroup)?
what is db2 restart?
What is cursor stability in db2?
can we update the table by using cursors can anyone post the query?
how to resolve -805 . how to see dbrm and package not found
What will the FREE command do to a plan?
How to resolve -407 sql code in DB2?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
How is the value function used?
What does the sqlcode of -818 pertain to?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
COBOL 
