CDC Guide for z/OS

10.5.4
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Condense Job Message Output

Review PowerExchange Condense job messages in the message log to determine the status of Condense processing.

The following example messages are for a Condense job that uses continuous extraction mode. The job ran and then was cold started from the earliest point in the change stream, as indicated by the restart tokens that are composed only of zeroes.

PWX-21605 Connection selected CHANGES found from covr< > tag< > type< IMS> int< FALSE> method< CONN_NAME>.
PWX-06365 Warning: Checkpoint file ABCDEF1.v101.I.CHKPTV0 could not be read and was ignored: Checkpoint FILE ABCDEF1.v101.I.CHKPTV0 Does not exist. OPEN retcodes 268/4/5896
PWX-06365 Warning: Checkpoint file ABCDEF1.v101.I.CHKPTV1 could not be read and was ignored: Checkpoint FILE ABCDEF1.v101.I.CHKPTV1 Does not exist. OPEN retcodes 268/4/5896
PWX-06365 Warning: Checkpoint file ABCDEF1.v101.I.CHKPTV2 could not be read and was ignored: Checkpoint FILE ABCDEF1.v101.I.CHKPTV2 Does not exist. OPEN retcodes 268/4/5896
PWX-06100 Sequence token 0000000000000000000000000000000000000000
PWX-06100 Logger   token 00000000000000000000000000000000
PWX-06103 Cold Start accepted
PWX-06121 Registration loaded: DBName: EDMA RegName: activ.1 Condense: Part20150923184534 Creator: FDPVF2 Table: ACTIV
PWX-06121 Registration loaded: DBName: EDMA RegName: address.1 Condense: Part20080225032112 Creator: HALADDR Table: ADDRESS
PWX-06121 Registration loaded: DBName: EDMA RegName: aprbin.1 Condense: Part20110820135824 Creator: APRNUM01 Table: APRBIN
PWX-06121 Registration loaded: DBName: EDMA RegName: aprchar.1 Condense: Part20110820135409 Creator: APRNUM01 Table: APRCHAR
PWX-06119 Controller: added new registration tag IMLEDMAactiv100000
PWX-06119 Controller: added new registration tag IMLEDMAaddress100000
PWX-06119 Controller: added new registration tag IMLEDMAaprbin100000
PWX-06119 Controller: added new registration tag IMLEDMAaprchar100000
PWX-06049 Controller: Cold start complete.

PWX-06112 Controller: Starting the capture subtasks.
 
PWX-06076 Starting Subtask program DTLCCMD0.
PWX-06450 Command Handler: Starting.
PWX-32533 The Service name or type is not available to the PWXCMD command handler. PWXCMD input is disabled.
PEV_CMDH_INIT_COMPLETE received
 
PWX-06076 Starting Subtask program DTLCCND3.
PWX-06400 Condense: Starting. Instance=EDMA.
PWX-06412 Condense: Registration Tag=IMLEDMAactiv100000
PWX-06412 Condense: Registration Tag=IMLEDMAaddress100000
PWX-06412 Condense: Registration Tag=IMLEDMAaprbin100000
PWX-06412 Condense: Registration Tag=IMLEDMAaprchar100000
 
PWX-06413 Condense: Highest Restart Token. Sequence=0000000000000000000000000000000000000000 PowerExchange Logger=00000000000000000000000000000000
PWX-09970 CAPI i/f: Changed 4 sources to earliest sequence token
PWX-09959 CAPI i/f: Earliest UOW restart tokens: Sequence=0000000000000000000000000000000000000000 PowerExchange Logger=E2C2F2D34040EFFFFFFFFFFFFFFFFFFF
PWX-09950 CAPI i/f: Connect OK. Sources = 4
PWX-06111 Controller: All tasks initialization complete.
PWX-06136 Checkpoint taken to file=ABCDEF1.v101.I.CHKPTV0 time=16/05/20 20:39:44
PWX-06111 Controller: All tasks initialization complete.
CMD Handler. Ignored Event 8 CONDENSE_INIT_COMPLETE
PWX-06455 Command Handler: received CAPTURE_STARTUP_COMPLETE event.
PWX-06417 Condense: Start to Condense because initialisation complete
PWX-09957 CAPI i/f: Read times out after 60 seconds
PWX-06419 Condense: Doing file switch. Records=658 Reason=Records criteria met Cdcts=48 
          CPU: TotMs=232640 Diff=232640
PWX-06418 Condense: Closed file ABCDEF1.v101.I.CND.CP160520.T2039001
PWX-06136 Checkpoint taken to file=ABCDEF1.v101.I.CHKPTV1 time=16/05/20 20:39:46
PWX-06420 Condense: Checkpoint done. Sequence=0000000AE744000000000000000AE74400000000 PowerExchange Logger=E2C2F2D340400000000015E200000000
PWX-06419 Condense: Doing file switch. Records=502 Reason=Records criteria met Cdcts=58 
          CPU: TotMs=488039 Diff=255399
PWX-06418 Condense: Closed file ABCDEF1.v101.I.CND.CP160520.T2039002
PWX-06136 Checkpoint taken to file=ABCDEF1.v101.I.CHKPTV2 time=16/05/20 20:39:48
PWX-06420 Condense: Checkpoint done. Sequence=000000101BE800000000000000101BE800000000 PowerExchange Logger=E2C2F2D340400000000015E200000000
PWX-06419 Condense: Doing file switch. Records=525 Reason=Records criteria met Cdcts=75 
          CPU: TotMs=742393 Diff=254354
PWX-06418 Condense: Closed file ABCDEF1.v101.I.CND.CP160520.T2039003
PWX-06136 Checkpoint taken to file=ABCDEF1.v101.I.CHKPTV0 time=16/05/20 20:39:49
PWX-06420 Condense: Checkpoint done. Sequence=000000173E7C00000000000000173E7C00000000 PowerExchange Logger=E2C2F2D340400000000015E200000000
PWX-06419 Condense: Doing file switch. Records=503 Reason=Records criteria met Cdcts=140 
          CPU: TotMs=1057980 Diff=315587
PWX-06418 Condense: Closed file ABCDEF1.v101.I.CND.CP160520.T2039004
PWX-06136 Checkpoint taken to file=ABCDEF1.v101.I.CHKPTV1 time=16/05/20 20:39:50
PWX-06420 Condense: Checkpoint done. Sequence=0000003183F2000000000000003183F200000000 PowerExchange Logger=E2C2F2D340400000002FF5BB00000000
PWX-09967 CAPI i/f: End of log for time 16/05/20 20:39:41 reached
PWX-06415 Condense: Condense completed. Total Records=2476, Data=2314, UOWs =118
PWX-06421 Condense: 16/05/20 20:40:53 Starting wait on commands for 5 minute
PWX-26011 Command handler received command "SHUTDOWN"
PWX-06463 Command Handler: Close Condense request is now queued.
PWX-06464 Command Handler: Shutdown will occur shortly.
PWX-06453 Command Handler: shutting down.
PWX-06454 Command Handler: has stopped.
PWX-06110 Unloaded module 1 (COMMAND_HANDLER).
PWX-06416 Condense: Shutting down because SHUTDOWN event received
PWX-06418 Condense: Closed file ABCDEF1.v101.I.CND.CP160520.T2039005
PWX-06136 Checkpoint taken to file=ABCDEF1.v101.I.CHKPTV2 time=16/05/20 20:45:41
PWX-06420 Condense: Checkpoint done. Sequence=0000003411E2000000000000003411E200000000 PowerExchange Logger=E2C2F2D340400000002FF5BB00000000
PWX-06414 Condense: Closing down CAPI
PWX-10780 CAPI: INFO: Extraction return counts: no data 2, commits 118, inserts 1708, updates 44, deletes 562.
PWX-10781 CAPI: INFO: Extraction subordinate read counts: no data 0, commits 406, inserts 1828, updates 59, deletes 786, backouts 10.
PWX-10782 CAPI: INFO: Extraction resource maximums: memory cache 433 KB, spill files 0.
PWX-10746 CAPI: INFO: Last data returned: timestamp 2016/05/13 17:44:28, sequence 0000003411E2000000000000003411E200000000.
PWX-10743 CAPI: INFO: No noteworthy transactions.
PWX-10749 CAPI: INFO: + Current subordinate sequence number 0000007A5F5100000000.
PWX-06401 Condense: Ending successfully.
PWX-06110 Unloaded module 2 (CONDENSE).
PWX-06060 Controller: subtask Command Handler ended.
PWX-06060 Controller: subtask Condense ended.
PWX-06107 Controller: All subtasks shut down.
PWX-06065 Controller: Condensing ended. Last checkpoint time 16/05/20 20:45:41.
PWX-06039 Controller: Ending.

The following table describes key messages in the output in ascending order by message ID:

Message	Description
PWX-06039	Reports that the Controller task is ending.
PWX-06060, PWX-6107	Indicates that the Controller detects that the Command Handler and Condense subtasks have shut down.
PWX-06065	Reports that condense processing is ending and provides the timestamp of the final checkpoint.
PWX-06076	Indicates that the DTLCCMD0 or DTLCCND3 subtask program for the Command Handler or Condense is starting. The Controller starts the Command Handler. After Command Handler startup is complete, the Controller starts the Condense subtask
PWX-06100	Shows the sequence token and restart token that were used for the PowerExchange Condense restart. Because both token values are all zeroes, PowerExchange Condense processing starts from the beginning of the PowerExchange Logger for z/OS active log files.
PWX-06103	Indicates that the operator responded Y to the PWX06101A WTOR message to confirm a cold start.
PWX-06110	Reports that the Command Handler or Condense module has been unloaded.
PWX-06111	Reports that Command Handler and Condense subtasks completed initialization.
PWX-06112	Reports that the Controller task is starting the Command Handler and Condense subtasks.
PWX-06119	Issued for each capture registration that the Controller task added for PowerExchange Condense processing. Reports the registration tag name.
PWX-06121	Issued for each capture registration that is loaded for processing. Reports the database name, registration name, Condense option, and source table name and creator.
PWX-06136	Reports that a checkpoint was taken. Includes the checkpoint file name and the date and time at which the checkpoint was taken.
PWX-06365	Indicates that none of the checkpoint data sets were found.
PWX-06400	Reports that the Condense subtask is starting for the instance that is specified in the DBID parameter in the CAPTPARM member.
PWX-06401	Indicates that the Condense subtask successfully shut down after closing open condense files and taking a final checkpoint.
PWX-06412	Issued for each capture registration that the Condense subtask will process. Reports the registration tag name.
PWX-06413	Lists the highest PowerExchange Condense restart tokens across all registration tags. Reports the following token types: Sequence . A 20-byte token value that includes UOW and sub-UOW sequences. Logger . A 16-byte token value that includes the PowerExchange Logger for z/OS started task name and the RBA of the last successfully processed UOW.
PWX-06414	Reports that the Condense subtask is closing the CAPI.
PWX-06415	Indicates the end of the condense cycle. Reports the total number of records processed, the number of insert, update, and delete records processed, and the number of UOWs processed. If no records were processed, this message is not issued.
PWX-06416	Reports that the Condense subtask received a PowerExchange Condense SHUTDOWN or pwxcmd shutdown command.
PWX-06417	Indicates that Condense processing is beginning.
PWX-06418	Indicates that the Condense subtask closed the specified condense file.
PWX-06419	Indicates that the Condense subtask is performing a condense file switch. Reports the number of records being processed, the reason for the file switch, number of different capture registrations for which PowerExchange Condense processed changes since the last file switch, CPU time used (in milliseconds), and the CPU time differential (in milliseconds) between this file switch and the last file switch. Reasons for the file switch include: Records criteria was met . A file switch occurred because the number of records that is specified by the FILE_SWITCH_VAL parameter was reached and the FILE_SWITCH_CRIT parameter is set to R for records. Minutes criteria met . A file switch occurred because the number of minutes that is specified by the FILE_SWITCH_VAL parameter was reached and the FILE_SWITCH_CRIT parameter is set to M for minutes. FILESWITCH request was received . A FILESWITCH command or pwxcmd fileswitch command was received.
PWX-06420	Indicates that the Condense subtask completed the checkpoint. Reports the PowerExchange Condense restart tokens in hexadecimal format.
PWX-06421	Indicates that the Condense task is going into a sleep state. Condense waits for the NO_DATA_WAIT period to expire or until a CONDENSE or pwxcmd condense command is received before starting the next condense cycle.
PWX-06450	Indicates that the Condense subtask is starting.
PWX-06453	Reports that the Command Handler is shutting down.
PWX-06454	Reports that the Command Handler has stopped.
PWX-06455	Reports that the Command Handler was notified that capture startup is complete.
PWX-06463, PWX-06404	Indicates that a SHUTDOWN or pwxcmd shutdown command was issued and is being processed.


PWX-09950	Reports that a connection to the CAPI was established and the number of registration tags.
PWX-09959	Reports the CAPI restart tokens in hexadecimal format for the earliest UOW.
PWX-09967	Indicates that PowerExchange Condense read all of the changes up to the end-of-log (EOL) for the specified date and time, when the condense cycle started. The NO_DATA_WAIT2 wait interval now takes effect. If PowerExchange Condense receives no additional changes, the condense task stops. Use this message to determine if PowerExchange Condense has captured committed changes for registered tables of interest. Look for this message if a condense file does not receive change data within the time period you expect. Delays can occur for various reasons.
PWX-09970	Reports that the Consumer API (CAPI) will use the earliest restart tokens to extract data for the specified number of registered sources. The CAPI uses the earliest restart tokens because the PowerExchange Condense restart tokens are all zeroes.
PWX-10743	Reports that no long-outstanding or large transactions were active at the end of the statistics interval.
PWX-10749	Provides information about the transaction that is associated with a spill file that the UOW Cleanser allocated while processing an IMS Fast Path cascade delete operation on segments.
PWX-10780, PWX-10781, PWX-10782	Provides extractions statistics from the CAPI.
PWX-21605	Indicates the CAPI_CONNECTION statement that is used. In the example message, the covr value is blank, which indicates the CONN_OVR parameter in not used. Instead, the CAPI_CONNECTION statement is taken from the DBMOVER file that the DTLCFG DD points to.
PWX-26011	Reports that the Command Handler subtask received a PowerExchange Condense SHUTDOWN or pwxcmd shutdown command.
PWX-32533	Indicates that a pwxcmd command handler cannot be started to handle pwxcmd commands for PowerExchange Condense that are issued from a remote machine. The required pwxcmd configuration tasks probably have not been completed correctly. To configure pwxcmd command handling, in the CAPTPARM configuration member, add a CONDENSENAME statement to define a name for the PowerExchange Condense command-handling service. Also, in the DBMOVER configuration file, add a SVCNODE statement that associates a port with the command-handling service.

Rename Saved Search

Table of Contents

CDC Guide for z/OS

CDC Guide for z/OS

Condense Job Message Output

Condense Job Message Output