What is syncpoint in Db2?
The DB2 commit must be synchronized with CICS, which means that your program must issue an EXEC CICS SYNCPOINT command. CICS then performs the commit processing with DB2. An implicit SYNCPOINT is always invoked by the EXEC CICS RETURN at end of task.
Which option is used to recover the recoverable resources up to the last syncpoint?
If the unit of work updates remote recoverable resources using an MRO or APPC session, the ROLLBACK option is propagated to the back-end transaction.
Which of the following table contains the relationship between transaction identifier and db2 application plan?
PCT. PCT is known as Program Control Table. It contains the Transaction IDs (TRANSID) and the corresponding program names or program IDs.
How does a CICS program work?
CICS authorizes users, allocates resources (real storage and cycles), and passes on database requests by the application to the appropriate database manager (such as DB2®). We could say that CICS acts like, and performs many of the same functions as the z/OS operating system.
What is PCT and PPT in CICS?
Terminal Control Table (TCT)—defines the remote systems to CICS. Program Control Table (PCT)—defines the local TPs to CICS. Program Processing Table (PPT)—defines the load module characteristics to CICS.
What is CICS Mor?
When enabled, multiregion operation (MRO) is used by CICS transactions to distribute their work across multiple regions, typically within a CICSplex. Each CICS region spawns a new task to perform the required function on behalf of the originating transaction.
What is the EXEC CICS syncpoint command used for?
The EXEC CICS® SYNCPOINT command is used to commit recoverable resources. In a DTP environment, the effect of the EXEC CICS SYNCPOINT command is propagated across all conversations that are using synchronization level 2.
What are CICS and syncpoint in recovery manager?
A CICS resource type declares itself to the Recovery Manager as threadsafe if the EXEC CICS commands relating to the resource type are threadsafe. SYNCPOINT divides a task (usually a long-running one) into smaller units of work. It specifies that all changes to recoverable resources made by the task since its last syncpoint are to be committed.
How does a sync point agent respond to sync point requests?
When a sync point agent receives the sync point request, it is given the opportunity to respond positively (to commit recoverable resources) with an EXEC CICS SYNCPOINT command or negatively (to back out recoverable resources) with an EXEC CICS SYNCPOINT ROLLBACK command.
What is EXEC CICS syncpoint rollback end-exec for unsuccessful SQLs?
EXEC CICS SYNCPOINT ROLLBACK END-EXEC, for unsuccessful sqls? EXEC SQL ROLLBACK will only rollback the database work done. Any other updates performed by CICS in the unit of work will not be rolled back. EXEC CICS SYNCPOINT (ROLLBACK) performs a two-phase COMMIT (ROLLBACK) of all resources affected by the CICS unit-of-work.