TPX batch update using extract file gives expected results even though there are error messages TPBL1010 return code is 8 and TPBL1054 means value not appropriate for this variable.

Document ID : KB000049658
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

EXTRACT GIVING (EXTFILE) PROFILE AND MATCHING SESSIONS
                         (PENTAPPL(CICSA---))
UPDATE USING(EXTFILE) (PENTAPPL(CICSB---))
 
 
TPBL1010 04/30/12.121 15:40:34.45 VPUT     PENTAPPL return code is    8
TPBL1054 04/30/12.121 15:40:34.45  means value not appropriate for this variable
TPBL1031 04/30/12.121 15:40:34.45   while Updating PUSERSP21
TPBL1037 04/30/12.121 15:40:34.45 No fields updated for PUSERSP21
TPBL1033 04/30/12.121 15:40:34.45 PUSERSP21         Prcssed
TPBL1033 04/30/12.121 15:40:34.55 PUSERSP21CICSA    UPDATed
TPBL1033 04/30/12.121 15:40:34.55 PBASEPROFCICSAA   UPDATed
TPBL1033 04/30/12.121 15:40:34.55 PBASEPROFCICSBB   UPDATed

Solution:

The extract PROFILE AND MATCHING SESSIONS results in an extract file containing one record for the profile plus individual records for each matching session within the profile. There is no way to extract only the session records.

The UPDATE statement will attempt to update the identified variable on each of the extracted records.

Since the variable PENTAPPL for Applid or Tier level is only on the profile session records, TPX batch puts out these messages indicating that this variable is not on the profile record, which is correct and expected:

TPBL1010 04/30/12.121 15:40:34.45 VPUT     PENTAPPL return code is    8
TPBL1054 04/30/12.121 15:40:34.45  means value not appropriate for this variable
TPBL1031 04/30/12.121 15:40:34.45   while Updating PUSERSP21
TPBL1037 04/30/12.121 15:40:34.45 No fields updated for PUSERSP21

NOTE: PUSERSP21 indicates Profile record for profile USERSP21

These are followed by the message indicating that this record was processed.

TPBL1033 04/30/12.121 15:40:34.45 PUSERSP21 Prcssed

Then the UPDATE attempts the next record which is successful so there is a message indicating that record was updated, not simply processed.

TPBL1033 04/30/12.121 15:40:34.55 PUSERSP21CICSA UPDATed

NOTE: PUSERSP21CICSA indicates Profile record for profile USERSP21 session CICSA.

Return code 8 is appropriate in this situation since you should be alerted to verify that the inability to update a particular record makes sense for the variables that you have specified.