TPT: system variables with result count

Tools & Utilities

TPT: system variables with result count

Hi everybody,

In the current implementation of our load scripts with multiload and tpump we are using the system variables holding the result count(&sysinscnt, &sysupdcnt, &sysetcnt, &sysuvcnt)  for logging and further processing.

With TPT those variables are not available any more, but we still need those figures. Is there any other way to receive the record counts of target and error tables than doing a select count on the tables manually or cutting the information from log file?

In the reference it is also said that in TPT C API the record counts are available. Are there any plans to make it accessable in TPT scripts?

Any help would be great!

Kind regards

Sebastian

16 REPLIES
Teradata Employee

Re: TPT: system variables with result count

The system variable enhancement has been on our list of features to implement for a long time. But, like everything else, features are prioritized and this one never seems to make it high enough.

In 14.10 we are implementing a feature by which all of the static and dynamically obtained metadata will be inserted into Teradata tables.

This will enable the users to use SQL to obtain any type of information from any job run on that Teradata system.

We feel this will be a more beneficial feature for the users.

Of course, this system variable feature will remain on our list and we will revisit the priorities in the 15.0 timeframe.

-- SteveF

Re: TPT: system variables with result count

That metadata approach sounds interesting, it doesn't have to be necessarily a system variable. As long as there is any method to get this information it will be fine. So I'm looking forward for that feature.

Enthusiast

Re: TPT: system variables with result count

Has the MLOAD system variables been added to the TPT product?   Besides the &sys vars.  we would like to know if there is a way to capture Table stats.  when using the MERGE statement.   Number of rows ins, Number of rows updated.

Thanks...   Tom

Teradata Employee

Re: TPT: system variables with result count

System variables have not been added to the TPT product yet. We are planning to add the system variables in the TPT 15.00 release.

Re: TPT: system variables with result count

Iam  trying to Develop a TPT script with multiple instances of the  DataConnector Operator to extract rows from a file and uses multiple instances of the Update Operator to perform upserts against two tables.

I am getting the following error while running it.

update_operator: TPT10378: Error 2 in allocating memory for TdpId buffer

**** 14:44:58 TPT10378: Error 2 in allocating memory for TdpId buffer

TPT_INFRA: TPT02242: Error: Operator synchronization error, status = Fatal Error

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0,

 Total Rows Sent = 0

Please  help me out to get rid of the issue.

Teradata Employee

Re: TPT: system variables with result count

Can you send me the TPT script and the TPT log?

Do you always get the TPT10378 error?

Re: TPT: system variables with result count

Yes Tony, everytime i get the above error. Please  find the script and log below:

efine job file_update

description 'loading of two teradata tables from a file'

(

 define schema Trans_n_acct_schema

 (

  acct_number  varchar(50),

  number       varchar(50),

  street  varchar(50),

  city  varchar(50),

  state  varchar(50),

  zip_code varchar(50),

  balance_fwd varchar(50),

  balance_cur varchar(50),

  trans_number varchar(50),

  trans_dt varchar(50),

  trans_id varchar(50),

  trans_amt  varchar(50)

 );

 define operator file_reader

 type dataconnector producer

 schema Trans_n_acct_schema

 attributes

 (

  varchar privatelogname  ='pvt_dataconnectorlog',

  varchar directorypath  ='D:\Users\subhedas\Cpg\CoE\TPT\Script',

  varchar filename  ='trans_account.txt',

  integer skiprows  =1,

  varchar format  ='Delimited',

  varchar openmode  ='Read',

  varchar TextDelimiter   ='|',

  varchar tracelevel  ='all'

 );

 define operator update_operator

 type update

 schema *

 attributes

 (

  varchar tpdid  ='**.**.**.**', /*the exact value of TPDID, userid and password has been replaced with * ...*/

  varchar username  ='****',

  varchar userpassword  ='****',

  varchar logtable  ='TD_BIM_FR_TRNG_DB.LG_acct_n_trans',

  varchar array targettable =['TD_BIM_FR_TRNG_DB.Trans_TPT','TD_BIM_FR_TRNG_DB.Accounts_TPT']

 );

 apply ('insert into TD_BIM_FR_TRNG_DB.Trans_TPT(Trans_Number,

       Trans_Date,

       Account_Number,

       Trans_ID,

       Trans_Amount )

       VALUES(:Trans_Number,

       :Trans_Dt,

       :Account_Number,

       :Trans_ID,

       :Trans_Amt);'),

  ('UPDATE TD_BIM_FR_TRNG_DB.Accounts_TPT

       SET Number = :Number,

       Street = :Street,

       City = :City,

       State = :State,

       Zip_Code = :Zip_Code,

       Balance_Forward = :Balance_fwd,

       Balance_Current = :Balance_cur

       WHERE Account_Number = :Account_Number;',

  'INSERT INTO TD_BIM_FR_TRNG_DB.Accounts_TPT (Account_Number,

       Number,

       Street,

       City,

       State,

       Zip_Code,

       Balance_Forward,

       Balance_Current)

       VALUES (:Account_Number,

       :Number,

       :Street,

       :City,

       :State,

       :Zip_Code,

       :Balance_fwd,

       :Balance_cur);')

  ignore duplicate update rows

  insert for missing update rows

  ignore missing update rows

  to operator (update_operator[2])

  select * from operator (file_reader[2]);

);

run log of  the above script:

........................

........................

     ===================================================================

     =                                                                 =

     =                  TERADATA PARALLEL TRANSPORTER                  =

     =                                                                 =

     =             UPDATE OPERATOR     VERSION 13.10.00.02             =

     =                                                                 =

     =          OPERATOR SUPPORT LIBRARY VERSION 13.10.00.02           =

     =                                                                 =

     = COPYRIGHT 2001-2010, TERADATA CORPORATION. ALL RIGHTS RESERVED. =

     =                                                                 =

     ===================================================================

**** 15:12:05 Processing starting at: Mon Jun 03 15:12:05 2013

     ===================================================================

     =                                                                 =

     =                      Module Identification                      =

     =                                                                 =

     ===================================================================

     Update Operator for Windows on DIN41001458

     UpdateMain : 13.10.00.06

     UpdateCLI  : 13.10.00.06

     UpdateUtil : 13.00.00.01

     PcomCLI    : 13.10.00.12

     PcomMBCS   : 13.00.00.02

     PcomMsgs   : 13.01.00.07

     PcomNtfy   : 13.00.00.03

     PcomPx     : 13.10.00.11

     PcomUtil   : 13.10.00.07

     PXICU      : 13.10.00.02

     TDICU      : 13.10.00.01

file_reader: TPT19012 No files assigned to instance 2.  This instance will be in

active.

file_reader: TPT19222 Operator instance 1 processing file 'D:\Users\subhedas\Cpg

\CoE\TPT\Script\trans_account.txt'.

update_operator: TPT10378: Error 2 in allocating memory for TdpId buffer

**** 15:12:05 TPT10378: Error 2 in allocating memory for TdpId buffer

TPT_INFRA: TPT02242: Error: Operator synchronization error, status = Fatal Error

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0,

 Total Rows Sent = 0

     ===================================================================

     =                                                                 =

     =                        Logoff/Disconnect                        =

     =                                                                 =

     ===================================================================

              Instance      Cpu Time

              ========  ================

                   1        0.27 Seconds

                   2        0.00 Seconds

**** 15:12:08 Total processor time used = '0.265202 Second(s)'

.        Start : Mon Jun 03 15:12:05 2013

.        End   : Mon Jun 03 15:12:08 2013

.        Highest return code encountered = '12'.

update_operator: Total processor time used = '0.265202 Second(s)'

update_operator: Start : Mon Jun 03 15:12:05 2013

update_operator: End   : Mon Jun 03 15:12:08 2013

**** 15:12:08 This job terminated

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0,

 Total Rows Sent = 0

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0,

 Total Rows Sent = 0

file_reader: TPT19221 Total files processed: 0.

Job step MAIN_STEP terminated (status 8)

Job subhedas terminated (status 8)

Total available memory:          10000000

Largest allocable area:          10000000

Memory use high water mark:         63592

Free map size:                       1024

Free map use high water mark:          22

Free list use high water mark:          0

Teradata Employee

Re: TPT: system variables with result count

Can you set the TPT Update operator's TraceLevel attribute to 'ALL' in the TPT job script?

Example:

VARCHAR TraceLevel = 'ALL',

Then, re-run the TPT job.

Send me the TPT log.

Re: TPT: system variables with result count

Hi Tony, Please find the log below after running with  VARCHAR TraceLevel = 'ALL',

TPT_INFRA: TPT04101: Warning: TMSM failed to initialize

Teradata Parallel Transporter Coordinator Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

Teradata Parallel Transporter Executor Version 13.10.00.02

PC_GETOPERATTRS: *************************************************

PC_GETOPERATTRS: entering handle:   0x1a16ea0

PC_GETOPERATTRS: MyOperatorName:    'update_operator'

PC_GETOPERATTRS: MyOperatorType:    2 (Prod=1, Cons=2, Stand=5)

PC_GETOPERATTRS: Instance number:   2

PC_GETOPERATTRS: Max instances:     2

PC_GETOPERATTRS: *************************************************

Teradata Parallel Transporter DataConnector Version 13.10.00.02

PC_GETOPERATTRS: RestartMode flag:  0

PC_GETOPERATTRS: entering handle:   0x18c6ea0

file_reader: TPT19206 Attribute 'TraceLevel' value reset to 'MILESTONES'.

file_reader: TPT19206 Attribute 'TraceLevel' value reset to 'MILESTONES'.

PC_GETOPERATTRS: Trace Level:       0x1f

PC_GETOPERATTRS: MyOperatorName:    'update_operator'

file_reader Instance 2 directing private log report to 'pvt_dataconnectorlog-2'.

file_reader Instance 1 directing private log report to 'pvt_dataconnectorlog-1'.

PC_GETOPERATTRS: PublicLog Handle:  0x1a16f58

PC_GETOPERATTRS: MyOperatorType:    2 (Prod=1, Cons=2, Stand=5)

PC_GETOPERATTRS: PrivateLog Handle: 0x0

PC_GETOPERATTRS: Instance number:   1

PC_GETOPERATTRS: bytes for glblmsg: 2097152

PC_GETOPERATTRS: Max instances:     2

PC_GETOPERATTRS: size of oper_desc: 304

PC_GETOPERATTRS: RestartMode flag:  0

PC_GETOPERATTRS: *************************************************

PC_GETOPERATTRS: Trace Level:       0x1f

PC_GETATTRIBUTE: entering

PC_GETOPERATTRS: PublicLog Handle:  0x18c6f58

PC_GETATTRIBUTE: attribute: 'SYSTEM_CharSetDefault'

PC_GETOPERATTRS: PrivateLog Handle: 0x0

PC_GETATTRIBUTE: mandatory: 0

PC_GETOPERATTRS: bytes for glblmsg: 2097152

PC_GETATTRIBUTE: attribute length: 1

PC_GETOPERATTRS: size of oper_desc: 304

PC_GETATTRIBUTE: successfully retrieved attribute

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: entering

PC_GETOPERATTRS: character set is default: 'T'

PC_GETATTRIBUTE: attribute: 'SYSTEM_CharSetDefault'

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute length: 1

PC_GETATTRIBUTE: attribute: 'SYSTEM_CharSetId'

PC_GETATTRIBUTE: successfully retrieved attribute

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: attribute length: 5

PC_GETOPERATTRS: character set is default: 'T'

PC_GETATTRIBUTE: successfully retrieved attribute

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: entering

PC_GETOPERATTRS: character set: not set by user

PC_GETATTRIBUTE: attribute: 'SYSTEM_CharSetId'

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute length: 5

PC_GETATTRIBUTE: attribute: 'SYSTEM_Checkpoint'

PC_GETATTRIBUTE: successfully retrieved attribute

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: attribute length: 4

PC_GETOPERATTRS: character set: not set by user

PC_GETATTRIBUTE: successfully retrieved attribute

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: entering

PC_GETOPERATTRS: checkpoint value: 0

PC_GETATTRIBUTE: attribute: 'SYSTEM_Checkpoint'

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute length: 4

PC_GETATTRIBUTE: attribute: 'DumpBytes'

PC_GETATTRIBUTE: successfully retrieved attribute

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: attribute: 'DumpBytes' not found

PC_GETOPERATTRS: checkpoint value: 0

PC_GETATTRIBUTE: optional attribute not found

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: entering

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: attribute: 'DumpBytes'

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'SYSTEM_APImode'

PC_GETATTRIBUTE: attribute: 'DumpBytes' not found

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: attribute: 'SYSTEM_APImode' not found

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: optional attribute not found

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: entering

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: attribute: 'SYSTEM_APImode'

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'SYSTEM_APImode' not found

PC_GETATTRIBUTE: attribute: 'LogSQL'

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: attribute: 'LogSQL' not found

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: optional attribute not found

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: entering

PC_GETOPERATTRS: *************************************************

PC_GETATTRIBUTE: attribute: 'LogSQL'

PC_INITOPERATOR: output starts now (already entered)

PC_GETATTRIBUTE: mandatory: 0

PC_GETPLATFORMENDIAN: entering

PC_GETATTRIBUTE: attribute: 'LogSQL' not found

PC_GETPLATFORMENDIAN: Platform_Endian default is LITTLE endian

PC_GETATTRIBUTE: optional attribute not found

PC_GETPLATFORMENDIAN: leaving

PC_GETATTRIBUTE: leaving

PC_GETSCHEMAHANDLE: entering

PC_GETOPERATTRS: *************************************************

PC_GETSCHEMAHANDLE: schema handle: 0xafcb84

PC_INITOPERATOR: output starts now (already entered)

PC_GETSCHEMAHANDLE: leaving

PC_GETCOLUMNSCHEMA: entering

PC_GETCOLUMNSCHEMA: address of list:     0x19e8918

PC_GETCOLUMNSCHEMA: number of columns:   12

PC_GETCOLUMNSCHEMA: received column handle: 0x19e88f4

PC_GETPLATFORMENDIAN: entering

PC_GETCOLUMNSCHEMA: received column handle: 0x19ec974

PC_GETPLATFORMENDIAN: Platform_Endian default is LITTLE endian

PC_GETCOLUMNSCHEMA: received column handle: 0x19f09f4

PC_GETPLATFORMENDIAN: leaving

PC_GETCOLUMNSCHEMA: received column handle: 0x19f4a74

Teradata Parallel Transporter Update Operator Version 13.10.00.02

PC_GETCOLUMNSCHEMA: received column handle: 0x19f8af4

update_operator: private log not specified

PC_GETCOLUMNSCHEMA: received column handle: 0x19fcb74

PC_CREATEGLOBALS: entering

file_reader: TPT19012 No files assigned to instance 2.  This instance will be inactive.

PC_GETCOLUMNSCHEMA: received column handle: 0x1a00bf4

file_reader: TPT19008 DataConnector Producer operator Instances: 2

PC_CREATEGLOBALS: creating slave global memory

PC_GETCOLUMNSCHEMA: received column handle: 0x1a04c74

file_reader: TPT19003 ECI operator ID: file_reader-4704

PC_CREATEGLOBALS: creating error global memory

PC_GETCOLUMNSCHEMA: received column handle: 0x1a08cf4

PC_CREATEGLOBALS: initializing slave memory for instance: 1

PC_GETCOLUMNSCHEMA: received column handle: 0x1a0cd74

file_reader: TPT19222 Operator instance 1 processing file 'D:\Users\subhedas\Cpg\CoE\TPT\Script\trans_acc

PC_CREATEGLOBALS: initializing error memory for instance: 1

PC_GETCOLUMNSCHEMA: received column handle: 0x1a10df4

PC_CREATEGLOBALS: initializing slave memory for instance: 2

PC_GETCOLUMNSCHEMA: received column handle: 0x1a14e74

PC_CREATEGLOBALS: initializing error memory for instance: 2

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2b980

PC_CREATEGLOBALS: creating session global memory

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'acct_number', 7, 50

PC_CREATEGLOBALS: initializing session global memory

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_CREATEGLOBALS: leaving with result: 0

PC_GETCOLUMNSCHEMA: attempting to malloc 12 bytes

PC_VALIDATECOLTYPE: entering with column type: 7

     ===================================================================

     =                                                                 =

     =                  TERADATA PARALLEL TRANSPORTER                  =

     =                                                                 =

     =             UPDATE OPERATOR     VERSION 13.10.00.02             =

     =                                                                 =

     =          OPERATOR SUPPORT LIBRARY VERSION 13.10.00.02           =

     =                                                                 =

     = COPYRIGHT 2001-2010, TERADATA CORPORATION. ALL RIGHTS RESERVED. =

     =                                                                 =

     ===================================================================

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2b9c0

**** 13:02:14 Processing starting at: Tue Jun 04 13:02:14 2013

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'number', 7, 50

PC_SHOWVERSION: entering

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_SHOWVERSION: operator name: Update

PC_GETCOLUMNSCHEMA: attempting to malloc 7 bytes

PC_VALIDATECOLTYPE: entering with column type: 7

     ===================================================================

     =                                                                 =

     =                      Module Identification                      =

     =                                                                 =

     ===================================================================

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2ba00

PC_SHOWVERSION: node name:   'DIN41001458'

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'street', 7, 50

     Update Operator for Windows on DIN41001458

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_SHOWVERSION: module id: 'UpdateMain', module vers: '13.10.00.06'

PC_GETCOLUMNSCHEMA: attempting to malloc 7 bytes

     UpdateMain : 13.10.00.06

PC_VALIDATECOLTYPE: entering with column type: 7

PC_SHOWVERSION: module id: 'UpdateCLI', module vers: '13.10.00.06'

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2ba40

     UpdateCLI  : 13.10.00.06

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'city', 7, 50

PC_SHOWVERSION: module id: 'UpdateUtil', module vers: '13.00.00.01'

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

     UpdateUtil : 13.00.00.01

PC_GETCOLUMNSCHEMA: attempting to malloc 5 bytes

PC_SHOWVERSION: module id: 'PcomCLI', module vers: '13.10.00.12'

PC_VALIDATECOLTYPE: entering with column type: 7

     PcomCLI    : 13.10.00.12

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2ba80

PC_SHOWVERSION: module id: 'PcomMBCS', module vers: '13.00.00.02'

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'state', 7, 50

     PcomMBCS   : 13.00.00.02

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_SHOWVERSION: module id: 'PcomMsgs', module vers: '13.01.00.07'

PC_GETCOLUMNSCHEMA: attempting to malloc 6 bytes

     PcomMsgs   : 13.01.00.07

PC_VALIDATECOLTYPE: entering with column type: 7

PC_SHOWVERSION: module id: 'PcomNtfy', module vers: '13.00.00.03'

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2bac0

     PcomNtfy   : 13.00.00.03

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'zip_code', 7, 50

PC_SHOWVERSION: module id: 'PcomPx', module vers: '13.10.00.11'

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

     PcomPx     : 13.10.00.11

PC_GETCOLUMNSCHEMA: attempting to malloc 9 bytes

PC_SHOWVERSION: module id: 'PcomUtil', module vers: '13.10.00.07'

PC_VALIDATECOLTYPE: entering with column type: 7

     PcomUtil   : 13.10.00.07

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2bb00

     PXICU      : 13.10.00.02

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'balance_fwd', 7, 50

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETCOLUMNSCHEMA: attempting to malloc 12 bytes

PC_VALIDATECOLTYPE: entering with column type: 7

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2bb40

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'balance_cur', 7, 50

     TDICU      : 13.10.00.01

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETCOLUMNSCHEMA: attempting to malloc 12 bytes

PC_SHOWVERSION: leaving

PC_VALIDATECOLTYPE: entering with column type: 7

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2bb80

PC_GETSCHEMAHANDLE: entering

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'trans_number', 7, 50

PC_GETSCHEMAHANDLE: schema handle: 0x7acb84

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETSCHEMAHANDLE: leaving

PC_GETCOLUMNSCHEMA: attempting to malloc 13 bytes

PC_GETCOLUMNSCHEMA: entering

PC_VALIDATECOLTYPE: entering with column type: 7

PC_GETCOLUMNSCHEMA: address of list:     0x1898918

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2bbc0

PC_GETCOLUMNSCHEMA: number of columns:   12

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'trans_dt', 7, 50

PC_GETCOLUMNSCHEMA: received column handle: 0x18988f4

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETCOLUMNSCHEMA: received column handle: 0x189c974

PC_GETCOLUMNSCHEMA: attempting to malloc 9 bytes

PC_GETCOLUMNSCHEMA: received column handle: 0x18a09f4

PC_VALIDATECOLTYPE: entering with column type: 7

PC_GETCOLUMNSCHEMA: received column handle: 0x18a4a74

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2bc00

PC_GETCOLUMNSCHEMA: received column handle: 0x18a8af4

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'trans_id', 7, 50

PC_GETCOLUMNSCHEMA: received column handle: 0x18acb74

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETCOLUMNSCHEMA: received column handle: 0x18b0bf4

PC_GETCOLUMNSCHEMA: attempting to malloc 9 bytes

PC_GETCOLUMNSCHEMA: received column handle: 0x18b4c74

PC_VALIDATECOLTYPE: entering with column type: 7

PC_GETCOLUMNSCHEMA: received column handle: 0x18b8cf4

PC_GETCOLUMNSCHEMA: allocated item list at: 0x1a2bc40

PC_GETCOLUMNSCHEMA: received column handle: 0x18bcd74

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'trans_amt', 7, 50

PC_GETCOLUMNSCHEMA: received column handle: 0x18c0df4

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETCOLUMNSCHEMA: received column handle: 0x18c4e74

PC_GETCOLUMNSCHEMA: attempting to malloc 10 bytes

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18db980

PC_VALIDATECOLTYPE: entering with column type: 7

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'acct_number', 7, 50

PC_GETCOLUMNSCHEMA:

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETCOLUMNSCHEMA: Final Column List

PC_GETCOLUMNSCHEMA: attempting to malloc 12 bytes

PC_GETCOLUMNSCHEMA: -----------------

PC_VALIDATECOLTYPE: entering with column type: 7

PC_GETCOLUMNSCHEMA: Address: 0x1a2b980, next: 0x1a2b9c0

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18db9c0

PC_GETCOLUMNSCHEMA: Address: 0x1a2b9c0, next: 0x1a2ba00

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'number', 7, 50

PC_GETCOLUMNSCHEMA: Address: 0x1a2ba00, next: 0x1a2ba40

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETCOLUMNSCHEMA: Address: 0x1a2ba40, next: 0x1a2ba80

PC_GETCOLUMNSCHEMA: attempting to malloc 7 bytes

PC_GETCOLUMNSCHEMA: Address: 0x1a2ba80, next: 0x1a2bac0

PC_VALIDATECOLTYPE: entering with column type: 7

PC_GETCOLUMNSCHEMA: Address: 0x1a2bac0, next: 0x1a2bb00

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dba00

PC_GETCOLUMNSCHEMA: Address: 0x1a2bb00, next: 0x1a2bb40

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'street', 7, 50

PC_GETCOLUMNSCHEMA: Address: 0x1a2bb40, next: 0x1a2bb80

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETCOLUMNSCHEMA: Address: 0x1a2bb80, next: 0x1a2bbc0

PC_GETCOLUMNSCHEMA: attempting to malloc 7 bytes

PC_GETCOLUMNSCHEMA: Address: 0x1a2bbc0, next: 0x1a2bc00

PC_VALIDATECOLTYPE: entering with column type: 7

PC_GETCOLUMNSCHEMA: Address: 0x1a2bc00, next: 0x1a2bc40

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dba40

PC_GETCOLUMNSCHEMA: Address: 0x1a2bc40, next: 0x0

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'city', 7, 50

PC_GETCOLUMNSCHEMA:

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_GETCOLUMNSCHEMA: itemhdr address: 0x1a2b980

PC_GETCOLUMNSCHEMA: attempting to malloc 5 bytes

PC_VALIDATECOLTYPE: entering with column type: 7

PC_OUTCOLLIST: ========================================

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dba80

PC_OUTCOLLIST:   1. Field Name: acct_number

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'state', 7, 50

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_OUTCOLLIST:      Size:  50

PC_GETCOLUMNSCHEMA: attempting to malloc 6 bytes

PC_OUTCOLLIST:      Prec:  0

PC_VALIDATECOLTYPE: entering with column type: 7

PC_OUTCOLLIST:      Scale: 0

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dbac0

PC_OUTCOLLIST:

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'zip_code', 7, 50

PC_OUTCOLLIST:   2. Field Name: number

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETCOLUMNSCHEMA: attempting to malloc 9 bytes

PC_OUTCOLLIST:      Size:  50

PC_VALIDATECOLTYPE: entering with column type: 7

PC_OUTCOLLIST:      Prec:  0

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dbb00

PC_OUTCOLLIST:      Scale: 0

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'balance_fwd', 7, 50

PC_OUTCOLLIST:

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_OUTCOLLIST:   3. Field Name: street

PC_GETCOLUMNSCHEMA: attempting to malloc 12 bytes

PC_OUTCOLLIST:      Type:  VARCHAR

PC_VALIDATECOLTYPE: entering with column type: 7

PC_OUTCOLLIST:      Size:  50

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dbb40

PC_OUTCOLLIST:      Prec:  0

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'balance_cur', 7, 50

PC_OUTCOLLIST:      Scale: 0

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_OUTCOLLIST:

PC_GETCOLUMNSCHEMA: attempting to malloc 12 bytes

PC_OUTCOLLIST:   4. Field Name: city

PC_VALIDATECOLTYPE: entering with column type: 7

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dbb80

PC_OUTCOLLIST:      Size:  50

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'trans_number', 7, 50

PC_OUTCOLLIST:      Prec:  0

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_OUTCOLLIST:      Scale: 0

PC_GETCOLUMNSCHEMA: attempting to malloc 13 bytes

PC_OUTCOLLIST:

PC_VALIDATECOLTYPE: entering with column type: 7

PC_OUTCOLLIST:   5. Field Name: state

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dbbc0

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'trans_dt', 7, 50

PC_OUTCOLLIST:      Size:  50

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_OUTCOLLIST:      Prec:  0

PC_GETCOLUMNSCHEMA: attempting to malloc 9 bytes

PC_OUTCOLLIST:      Scale: 0

PC_VALIDATECOLTYPE: entering with column type: 7

PC_OUTCOLLIST:

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dbc00

PC_OUTCOLLIST:   6. Field Name: zip_code

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'trans_id', 7, 50

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_OUTCOLLIST:      Size:  50

PC_GETCOLUMNSCHEMA: attempting to malloc 9 bytes

PC_OUTCOLLIST:      Prec:  0

PC_VALIDATECOLTYPE: entering with column type: 7

PC_OUTCOLLIST:      Scale: 0

PC_GETCOLUMNSCHEMA: allocated item list at: 0x18dbc40

PC_OUTCOLLIST:

PC_GETCOLUMNSCHEMA: Name, Type, Size: 'trans_amt', 7, 50

PC_OUTCOLLIST:   7. Field Name: balance_fwd

PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETCOLUMNSCHEMA: attempting to malloc 10 bytes

PC_OUTCOLLIST:      Size:  50

PC_VALIDATECOLTYPE: entering with column type: 7

PC_OUTCOLLIST:      Prec:  0

PC_GETCOLUMNSCHEMA:

PC_OUTCOLLIST:      Scale: 0

PC_GETCOLUMNSCHEMA: Final Column List

PC_OUTCOLLIST:

PC_GETCOLUMNSCHEMA: -----------------

PC_OUTCOLLIST:   8. Field Name: balance_cur

PC_GETCOLUMNSCHEMA: Address: 0x18db980, next: 0x18db9c0

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETCOLUMNSCHEMA: Address: 0x18db9c0, next: 0x18dba00

PC_OUTCOLLIST:      Size:  50

PC_GETCOLUMNSCHEMA: Address: 0x18dba00, next: 0x18dba40

PC_OUTCOLLIST:      Prec:  0

PC_GETCOLUMNSCHEMA: Address: 0x18dba40, next: 0x18dba80

PC_OUTCOLLIST:      Scale: 0

PC_GETCOLUMNSCHEMA: Address: 0x18dba80, next: 0x18dbac0

PC_OUTCOLLIST:

PC_GETCOLUMNSCHEMA: Address: 0x18dbac0, next: 0x18dbb00

PC_OUTCOLLIST:   9. Field Name: trans_number

PC_GETCOLUMNSCHEMA: Address: 0x18dbb00, next: 0x18dbb40

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETCOLUMNSCHEMA: Address: 0x18dbb40, next: 0x18dbb80

PC_OUTCOLLIST:      Size:  50

PC_GETCOLUMNSCHEMA: Address: 0x18dbb80, next: 0x18dbbc0

PC_OUTCOLLIST:      Prec:  0

PC_GETCOLUMNSCHEMA: Address: 0x18dbbc0, next: 0x18dbc00

PC_OUTCOLLIST:      Scale: 0

PC_GETCOLUMNSCHEMA: Address: 0x18dbc00, next: 0x18dbc40

PC_OUTCOLLIST:

PC_GETCOLUMNSCHEMA: Address: 0x18dbc40, next: 0x0

PC_OUTCOLLIST:  10. Field Name: trans_dt

PC_GETCOLUMNSCHEMA:

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETCOLUMNSCHEMA: itemhdr address: 0x18db980

PC_OUTCOLLIST:      Size:  50

PC_OUTCOLLIST:      Prec:  0

PC_OUTCOLLIST: ========================================

PC_OUTCOLLIST:      Scale: 0

PC_OUTCOLLIST:   1. Field Name: acct_number

PC_OUTCOLLIST:

PC_OUTCOLLIST:      Type:  VARCHAR

PC_OUTCOLLIST:  11. Field Name: trans_id

PC_OUTCOLLIST:      Size:  50

PC_OUTCOLLIST:      Type:  VARCHAR

PC_OUTCOLLIST:      Prec:  0

PC_OUTCOLLIST:      Size:  50

PC_OUTCOLLIST:      Scale: 0

PC_OUTCOLLIST:      Prec:  0

PC_OUTCOLLIST:

PC_OUTCOLLIST:      Scale: 0

PC_OUTCOLLIST:   2. Field Name: number

PC_OUTCOLLIST:

PC_OUTCOLLIST:      Type:  VARCHAR

PC_OUTCOLLIST:  12. Field Name: trans_amt

PC_OUTCOLLIST:      Size:  50

PC_OUTCOLLIST:      Type:  VARCHAR

PC_OUTCOLLIST:      Prec:  0

PC_OUTCOLLIST:      Size:  50

PC_OUTCOLLIST:      Scale: 0

PC_OUTCOLLIST:      Prec:  0

PC_OUTCOLLIST:

PC_OUTCOLLIST:      Scale: 0

PC_OUTCOLLIST:   3. Field Name: street

PC_OUTCOLLIST:

PC_OUTCOLLIST:      Type:  VARCHAR

PC_OUTCOLLIST: There are 12 fields defined

PC_OUTCOLLIST:      Size:  50

PC_OUTCOLLIST: ========================================

PC_OUTCOLLIST:      Prec:  0

PC_OUTCOLLIST:      Scale: 0

PC_GETCOLUMNSCHEMA: leaving

PC_OUTCOLLIST:

PC_INITOPERATOR: latency flag is: 0

PC_OUTCOLLIST:   4. Field Name: city

PC_INITOPERATOR: leaving

PC_OUTCOLLIST:      Type:  VARCHAR

INITIATE: phase 1

PC_OUTCOLLIST:      Size:  50

INITMYOPERATOR: entering

PC_OUTCOLLIST:      Prec:  0

INITMYOPERATOR: allocated private area at: 0x19e3080

PC_OUTCOLLIST:      Scale: 0

INITMYOPERATOR: number of bytes allocated: 68

PC_OUTCOLLIST:

INITMYOPERATOR: allocated event area at:   0x1a2d168

PC_OUTCOLLIST:   5. Field Name: state

INITMYOPERATOR: leaving

PC_OUTCOLLIST:      Type:  VARCHAR

PC_INITCLIOPER: entering

PC_OUTCOLLIST:      Size:  50

PC_INITCLIAREA: entering

PC_OUTCOLLIST:      Prec:  0

PC_INITCLIAREA: allocating CLI area, size: 1056

PC_OUTCOLLIST:      Scale: 0

PC_INITCLIAREA: allocated CLI area, addr:  0x1a2d4b8

PC_OUTCOLLIST:

PC_INITCLIAREA: allocated reqstr, addr:  0x1a2d8e0

PC_OUTCOLLIST:   6. Field Name: zip_code

PC_INITCLIAREA: allocated partition, addr:  0x1a2c4c0

PC_OUTCOLLIST:      Type:  VARCHAR

PC_INITCLIAREA: allocated CharSet, addr:  0xaf8630

PC_OUTCOLLIST:      Size:  50

PC_INITCLIAREA: leaving

PC_OUTCOLLIST:      Prec:  0

PC_GETCLIATTRS: entering

PC_OUTCOLLIST:      Scale: 0

PC_GETATTRIBUTE: entering

PC_OUTCOLLIST:

PC_GETATTRIBUTE: attribute: 'TdpId'

PC_OUTCOLLIST:   7. Field Name: balance_fwd

PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSExternalName'

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETATTRIBUTE: mandatory: 0

PC_OUTCOLLIST:      Size:  50

PC_GETATTRIBUTE: attribute: 'TdpId' not found

PC_OUTCOLLIST:      Prec:  0

PC_GETATTRIBUTE: retrieving alternate: 'SYSTEM_DBMSExternalName'

PC_OUTCOLLIST:      Scale: 0

PC_GETATTRIBUTE: optional attribute not found

PC_OUTCOLLIST:

PC_GETATTRIBUTE: leaving

PC_OUTCOLLIST:   8. Field Name: balance_cur

PC_GETCLIATTRS: *************************************************

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETATTRIBUTE: entering

PC_OUTCOLLIST:      Size:  50

PC_GETATTRIBUTE: attribute: 'UserName'

PC_OUTCOLLIST:      Prec:  0

PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSUserName'

PC_OUTCOLLIST:      Scale: 0

PC_GETATTRIBUTE: mandatory: 0

PC_OUTCOLLIST:

PC_GETATTRIBUTE: attribute length: 8

PC_OUTCOLLIST:   9. Field Name: trans_number

PC_GETATTRIBUTE: successfully retrieved attribute

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETATTRIBUTE: leaving

PC_OUTCOLLIST:      Size:  50

PC_GETCLIATTRS: logon user id: 'TD_USER5'

PC_OUTCOLLIST:      Prec:  0

PC_GETCLIATTRS: *************************************************

PC_OUTCOLLIST:      Scale: 0

PC_GETCLIATTRS: logon password: <not displayable>

PC_OUTCOLLIST:

PC_GETCLIATTRS: *************************************************

PC_OUTCOLLIST:  10. Field Name: trans_dt

PC_GETATTRIBUTE: entering

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETATTRIBUTE: attribute: 'AccountId'

PC_OUTCOLLIST:      Size:  50

PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSAccountId'

PC_OUTCOLLIST:      Prec:  0

PC_GETATTRIBUTE: mandatory: 0

PC_OUTCOLLIST:      Scale: 0

PC_GETATTRIBUTE: attribute: 'AccountId' not found

PC_OUTCOLLIST:

PC_GETATTRIBUTE: retrieving alternate: 'SYSTEM_DBMSAccountId'

PC_OUTCOLLIST:  11. Field Name: trans_id

PC_GETATTRIBUTE: optional attribute not found

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETATTRIBUTE: leaving

PC_OUTCOLLIST:      Size:  50

PC_GETCLIATTRS: *************************************************

PC_OUTCOLLIST:      Prec:  0

PC_GETATTRIBUTE: entering

PC_OUTCOLLIST:      Scale: 0

PC_GETATTRIBUTE: attribute: 'WorkingDatabase'

PC_OUTCOLLIST:

PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSWorkingDatabase'

PC_OUTCOLLIST:  12. Field Name: trans_amt

PC_GETATTRIBUTE: mandatory: 0

PC_OUTCOLLIST:      Type:  VARCHAR

PC_GETATTRIBUTE: attribute: 'WorkingDatabase' not found

PC_OUTCOLLIST:      Size:  50

PC_GETATTRIBUTE: retrieving alternate: 'SYSTEM_DBMSWorkingDatabase'

PC_OUTCOLLIST:      Prec:  0

PC_GETATTRIBUTE: optional attribute not found

PC_OUTCOLLIST:      Scale: 0

PC_GETATTRIBUTE: leaving

PC_OUTCOLLIST:

PC_GETCLIATTRS: *************************************************

PC_OUTCOLLIST: There are 12 fields defined

PC_GETATTRIBUTE: entering

PC_OUTCOLLIST: ========================================

PC_GETATTRIBUTE: attribute: 'TenacityHours'

PC_GETATTRIBUTE: mandatory: 0

PC_GETCOLUMNSCHEMA: leaving

PC_GETATTRIBUTE: attribute: 'TenacityHours' not found

PC_INITOPERATOR: latency flag is: 0

PC_GETATTRIBUTE: optional attribute not found

PC_INITOPERATOR: leaving

PC_GETATTRIBUTE: leaving

INITIATE: phase 1

PC_GETCLIATTRS: *************************************************

INITMYOPERATOR: entering

PC_GETATTRIBUTE: entering

INITMYOPERATOR: allocated private area at: 0x1893080

PC_GETATTRIBUTE: attribute: 'TenacitySleep'

INITMYOPERATOR: number of bytes allocated: 68

PC_GETATTRIBUTE: mandatory: 0

INITMYOPERATOR: allocated event area at:   0x7acbd0

PC_GETATTRIBUTE: attribute: 'TenacitySleep' not found

INITMYOPERATOR: leaving

PC_GETATTRIBUTE: optional attribute not found

PC_INITCLIOPER: entering

PC_GETATTRIBUTE: leaving

PC_INITCLIAREA: entering

PC_GETCLIATTRS: *************************************************

PC_INITCLIAREA: allocating CLI area, size: 1056

PC_GETATTRIBUTE: entering

PC_INITCLIAREA: allocated CLI area, addr:  0x7acf20

PC_GETATTRIBUTE: attribute: 'MaxSessions'

PC_INITCLIAREA: allocated reqstr, addr:  0x7ad348

PC_GETATTRIBUTE: mandatory: 0

PC_INITCLIAREA: allocated partition, addr:  0x18dc520

PC_GETATTRIBUTE: attribute: 'MaxSessions' not found

PC_INITCLIAREA: allocated CharSet, addr:  0x7a8658

PC_GETATTRIBUTE: optional attribute not found

PC_INITCLIAREA: leaving

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: entering

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'TdpId'

PC_GETATTRIBUTE: attribute: 'MinSessions'

PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSExternalName'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'MinSessions' not found

PC_GETATTRIBUTE: attribute: 'TdpId' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: retrieving alternate: 'SYSTEM_DBMSExternalName'

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: optional attribute not found

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: entering

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: attribute: 'DateForm'

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'UserName'

PC_GETATTRIBUTE: attribute: 'DateForm' not found

PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSUserName'

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: attribute length: 8

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: successfully retrieved attribute

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: attribute: 'DataEncryption'

PC_GETCLIATTRS: logon user id: 'TD_USER5'

PC_GETATTRIBUTE: mandatory: 0

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: attribute: 'DataEncryption' not found

PC_GETCLIATTRS: logon password: <not displayable>

PC_GETATTRIBUTE: optional attribute not found

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: entering

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: attribute: 'AccountId'

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSAccountId'

PC_GETATTRIBUTE: attribute: 'LogonMech'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'AccountId' not found

PC_GETATTRIBUTE: attribute: 'LogonMech' not found

PC_GETATTRIBUTE: retrieving alternate: 'SYSTEM_DBMSAccountId'

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: *************************************************

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'LogonMechData'

PC_GETATTRIBUTE: attribute: 'WorkingDatabase'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSWorkingDatabase'

PC_GETATTRIBUTE: attribute: 'LogonMechData' not found

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: attribute: 'WorkingDatabase' not found

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: retrieving alternate: 'SYSTEM_DBMSWorkingDatabase'

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: attribute: 'ReplicationOverride'

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'ReplicationOverride' not found

PC_GETATTRIBUTE: attribute: 'TenacityHours'

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: attribute: 'TenacityHours' not found

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: optional attribute not found

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: entering

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: attribute: 'DiagnosticRestartMask'

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'TenacitySleep'

PC_GETATTRIBUTE: attribute: 'DiagnosticRestartMask' not found

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: attribute: 'TenacitySleep' not found

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: optional attribute not found

PC_GETCLIATTRS: diag mask (hex): 0

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: *************************************************

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'DiagnosticRestartCounter'

PC_GETATTRIBUTE: attribute: 'MaxSessions'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'DiagnosticRestartCounter' not found

PC_GETATTRIBUTE: attribute: 'MaxSessions' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: diag counter: 0

PC_GETCLIATTRS: *************************************************

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETCLIATTRS: leaving

PC_GETATTRIBUTE: attribute: 'MinSessions'

PC_INITCLI: entering

PC_GETATTRIBUTE: mandatory: 0

PC_INITCLI: allocated default DBCAREA at: 0x1a2dce8

PC_GETATTRIBUTE: attribute: 'MinSessions' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'DateForm'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'DateForm' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'DataEncryption'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'DataEncryption' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'LogonMech'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'LogonMech' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'LogonMechData'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'LogonMechData' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'ReplicationOverride'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'ReplicationOverride' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: *************************************************

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'DiagnosticRestartMask'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'DiagnosticRestartMask' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: diag mask (hex): 0

PC_GETCLIATTRS: *************************************************

PC_GETATTRIBUTE: entering

PC_GETATTRIBUTE: attribute: 'DiagnosticRestartCounter'

PC_GETATTRIBUTE: mandatory: 0

PC_GETATTRIBUTE: attribute: 'DiagnosticRestartCounter' not found

PC_GETATTRIBUTE: optional attribute not found

PC_GETATTRIBUTE: leaving

PC_GETCLIATTRS: diag counter: 0

PC_GETCLIATTRS: *************************************************

PC_GETCLIATTRS: leaving

PC_INITCLI: entering

PC_INITCLI: allocated default DBCAREA at: 0x7ad750

PC_INITCLI: DBCHINI returns charset string: 'ASCII                         '

PC_INITCLI: DBCHINI returns charset type:   ' '

PC_GETDEFAULTTDPID: entering

PC_ISSUEDBCHQE: entering

PC_ISSUEDBCHQE: UseTDP:   1

PC_ISSUEDBCHQE: qepItem:  49

PC_ISSUEDBCHQE: qepLevel: 0x81

PC_ISSUEDBCHQE: using SESS ID for this query

PC_ISSUEDBCHQE: calling DBCHQE for session: 0

PC_ISSUEDBCHQE: leaving with Supported flag: 1

PC_ISSUEDBCHQE: leaving with return code:    0

PC_SETCODE: entering

PC_INITCLI: DBCHINI returns charset string: 'ASCII                        '

PC_SETCODE: current condition code: 0

PC_INITCLI: DBCHINI returns charset type:   ' '

PC_GETDEFAULTTDPID: entering

PC_SETCODE: setting condition code: 12

PC_ISSUEDBCHQE: entering

PC_SETCODE: leaving

PC_ISSUEDBCHQE: UseTDP:   1

PC_ISSUEDBCHQE: qepItem:  49

update_operator: TPT10378: Error 2 in allocating memory for TdpId buffer

PC_ISSUEDBCHQE: qepLevel: 0x81

**** 13:02:14 TPT10378: Error 2 in allocating memory for TdpId buffer

PC_ISSUEDBCHQE: using SESS ID for this query

PC_GETDEFAULTTDPID: error 2 allocating TdpId buffer

PC_ISSUEDBCHQE: calling DBCHQE for session: 0

PC_GETDEFAULTTDPID: leaving

PC_ISSUEDBCHQE: leaving with Supported flag: 1

PC_INITCLI: leaving with return code: -998

PC_ISSUEDBCHQE: leaving with return code:    0

PC_ISRETRY: entering with result, DBSError: -998, 0

PC_SETCODE: entering

PC_ISRETRY: leaving with return code: 0

PC_SETCODE: current condition code: 0

PC_INITCLIOPER: leaving with FATAL error

PC_SETCODE: setting condition code: 12

PC_SETCODE: leaving

update_operator: TPT10378: Error 2 in allocating memory for TdpId buffer

**** 13:02:14 TPT10378: Error 2 in allocating memory for TdpId buffer

PC_GETDEFAULTTDPID: error 2 allocating TdpId buffer

PC_GETDEFAULTTDPID: leaving

PC_INITCLI: leaving with return code: -998

PC_ISRETRY: entering with result, DBSError: -998, 0

PC_ISRETRY: leaving with return code: 0

PC_INITCLIOPER: leaving with FATAL error

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0

PC_CHECKOPERINIT: entering

PC_REPORTERROR: entering

PC_REPORTERROR: error message global memory, instance 1

PC_REPORTERROR: code: 0

PC_REPORTERROR: sev:  0

PC_REPORTERROR: type: 0

PC_REPORTERROR: arg1: 0

PC_REPORTERROR: arg2: 0

PC_REPORTERROR: arg3: 0

PC_REPORTERROR: arg4: 0

PC_REPORTERROR: arg5: 0

PC_REPORTERROR: len1:  0

PC_REPORTERROR: msg1:

PC_REPORTERROR: len2:  0

PC_REPORTERROR: msg2:

PC_REPORTERROR: len3:  0

PC_REPORTERROR: msg3:

PC_CLEARERRORINFO: entering

PC_CLEARERRORINFO: leaving

PC_REPORTERROR: error message global memory, instance 2

PC_REPORTERROR: code: 0

PC_REPORTERROR: sev:  0

PC_REPORTERROR: type: 0

PC_REPORTERROR: arg1: 0

PC_REPORTERROR: arg2: 0

PC_REPORTERROR: arg3: 0

PC_REPORTERROR: arg4: 0

PC_REPORTERROR: arg5: 0

PC_REPORTERROR: len1:  0

PC_REPORTERROR: msg1:

PC_REPORTERROR: len2:  0

PC_REPORTERROR: msg2:

PC_REPORTERROR: len3:  0

PC_REPORTERROR: msg3:

PC_CLEARERRORINFO: entering

PC_CLEARERRORINFO: leaving

PC_REPORTERROR: leaving with return code: 0

PC_GETCPUTIME: entering

PC_GETCPUTIME: leaving

PC_UPDATESLAVEINFO: ************************************************

PC_UPDATESLAVEINFO: entering

PC_UPDATESLAVEINFO: Instance: 1 after read

PC_UPDATESLAVEINFO: Number of Bytes:     48

PC_UPDATESLAVEINFO: Sessions To Connect: 0

PC_UPDATESLAVEINFO: Sessions Connected:  0

PC_UPDATESLAVEINFO: Total Rows Loaded:   0

PC_UPDATESLAVEINFO: Total Error Rows:    0

PC_UPDATESLAVEINFO: Connect Result:      0

PC_UPDATESLAVEINFO: Cpu Time:            0

PC_UPDATESLAVEINFO: Number Of Stmts:     0

PC_UPDATESLAVEINFO: Rows Exported:       0

PC_UPDATESLAVEINFO: Rows Sent To DBS     0

PC_UPDATESLAVEINFO: Number of Blocks     0

PC_UPDATESLAVEINFO: updating CpuTime field

PC_UPDATESLAVEINFO: Instance: 1 before write

PC_UPDATESLAVEINFO: Number of Bytes:     48

PC_UPDATESLAVEINFO: Sessions To Connect: 0

PC_UPDATESLAVEINFO: Sessions Connected:  0

PC_UPDATESLAVEINFO: Total Rows Loaded:   0

PC_UPDATESLAVEINFO: Total Error Rows:    0

PC_UPDATESLAVEINFO: Connect Result:      0

PC_UPDATESLAVEINFO: Cpu Time:            0.280802

PC_UPDATESLAVEINFO: Number Of Stmts:     0

PC_UPDATESLAVEINFO: Rows Exported:       0

PC_UPDATESLAVEINFO: Rows Sent To DBS     0

PC_UPDATESLAVEINFO: Number of Blocks     0

PC_UPDATESLAVEINFO: leaving with result: 0

PC_UPDATESLAVEINFO: ************************************************

PC_CHECKOPERINIT: leaving

TERMINATE: phase 1

PC_DISCCLIOPER: entering

     ===================================================================

     =                                                                 =

     =                        Logoff/Disconnect                        =

     =                                                                 =

     ===================================================================

PC_DOLOGOFFSPEC: entering

PC_DOLOGOFFSPEC: logging off Special Sessions

PC_DOLOGOFFSPEC: Special Sessions never connected

PC_DOLOGOFFSPEC: leaving

PC_DOLOGOFFSQL: entering

PC_DOLOGOFFSQL: logging off Auxiliary SQL Session

PC_DOLOGOFFSQL: Auxiliary SQL Session never connected

PC_DOLOGOFFSQL: logging off Main SQL Session

PC_DOLOGOFFSQL: Main SQL Session never connected

PC_DOLOGOFFSQL: leaving

PC_DISCCLIOPER: leaving

TERMINATE: phase 2

PC_LOGJOBMETADATA: entering

PC_LOGJOBMETADATA: leaving

PC_OUTPUTCPU: entering

PC_OUTPUTCPU: start time: 'Tue Jun 04 13:02:14 2013'

PC_OUTPUTCPU: start time: 'Tue Jun 04 13:02:14 2013'

PC_OUTPUTCPU: stop  time: 'Tue Jun 04 13:02:14 2013'

              Instance      Cpu Time

              ========  ================

PC_GETSLAVEINFO: *************************************************

PC_GETSLAVEINFO: entering

PC_GETSLAVEINFO: Instance: 1

PC_GETSLAVEINFO: field:    7

PC_GETSLAVEINFO: Sessions To Connect: 0

PC_GETSLAVEINFO: Sessions Connected:  0

PC_GETSLAVEINFO: Connect Result:      0

PC_GETSLAVEINFO: Total Rows Loaded:   0

PC_GETSLAVEINFO: Total Error Rows:    0

PC_GETSLAVEINFO: Number Of Stmts:     0

PC_GETSLAVEINFO: Rows Exported:       0

PC_GETSLAVEINFO: Rows Sent To DBS     0

PC_GETSLAVEINFO: Cpu Time:            0.280802

PC_GETSLAVEINFO: Number of Blocks:    0

PC_GETSLAVEINFO: NoSpool Export:      0

PC_GETSLAVEINFO: retrieving CpuTime field

PC_GETSLAVEINFO: returning value: 0.280802

PC_GETSLAVEINFO: leaving

PC_GETSLAVEINFO: *************************************************

                   1        0.28 Seconds

PC_GETSLAVEINFO: *************************************************

PC_GETSLAVEINFO: entering

PC_GETSLAVEINFO: Instance: 2

PC_GETSLAVEINFO: field:    7

PC_GETSLAVEINFO: Sessions To Connect: 0

PC_GETSLAVEINFO: Sessions Connected:  0

PC_GETSLAVEINFO: Connect Result:      0

PC_GETSLAVEINFO: Total Rows Loaded:   0

PC_GETSLAVEINFO: Total Error Rows:    0

PC_GETSLAVEINFO: Number Of Stmts:     0

PC_GETSLAVEINFO: Rows Exported:       0

PC_GETSLAVEINFO: Rows Sent To DBS     0

PC_GETSLAVEINFO: Cpu Time:            0.000000

PC_GETSLAVEINFO: Number of Blocks:    0

PC_GETSLAVEINFO: NoSpool Export:      0

PC_GETSLAVEINFO: retrieving CpuTime field

PC_GETSLAVEINFO: returning value: 0.000000

PC_GETSLAVEINFO: leaving

PC_GETSLAVEINFO: *************************************************

                   2        0.00 Seconds

**** 13:02:14 Total processor time used = '0.280802 Second(s)'

.        Start : Tue Jun 04 13:02:14 2013

.        End   : Tue Jun 04 13:02:14 2013

.        Highest return code encountered = '12'.

update_operator: Total processor time used = '0.280802 Second(s)'

update_operator: Start : Tue Jun 04 13:02:14 2013

update_operator: End   : Tue Jun 04 13:02:14 2013

PC_OUTPUTCPU: leaving

PC_TERMNOTIFY: entering

PC_TERMNOTIFY: leaving

PC_TERMCLIOPER: entering

**** 13:02:14 This job terminated

PC_FREECLIAREA: entering

PC_FREECLIAREA: checking 64K output buffer

PC_FREECLIAREA: checking checkpoint buffer

PC_FREECLIAREA: checking main logon string buffer

PC_FREECLIAREA: checking special logon string buffer

PC_FREECLIAREA: checking query band session info buffer

PC_FREECLIAREA: checking request buffer

PC_FREECLIAREA: deallocating request buffer at: 0x7ad348

PC_FREECLIAREA: checking partition buffer

PC_FREECLIAREA: deallocating partition buffer at: 0x18dc520

PC_FREECLIAREA: checking character set buffer

PC_FREECLIAREA: deallocating character set buffer at: 0x7a8658

PC_FREECLIAREA: checking default DBCAREA buffer

PC_FREECLIAREA: deallocating default DBCAREA at: 0x7ad750

PC_FREECLIAREA: checking main DBCAREA buffer

PC_FREECLIAREA: checking Aux DBCAREA buffer

PC_FREECLIAREA: checking Special DBCAREA buffer

PC_FREECLIAREA: checking DBC DBCAREA buffer

PC_FREECLIAREA: checking session list

PC_FREECLIAREA: checking DBCHWL session list

PC_FREECLIAREA: checking session array

PC_FREECLIAREA: deallocating TdpId at: 0x18e83f8

PC_FREECLIAREA: calling CLI to clean up its internal buffers

PC_CLEANCLI: entering

PC_CLEANCLI: calling DBCHCLN

PC_CLEANCLI: leaving

PC_FREECLIAREA: deallocating CLI area pointer at: 0x7acf20

PC_FREECLIAREA: leaving

PC_TERMCLIOPER: leaving

CLEANUP: entering

CLEANUP: deallocating event area at: 0x7acbd0

CLEANUP: deallocating private_oper_area at: 0x1893080

CLEANUP: leaving

PC_DELETEGLOBALS: entering

PC_DELETEGLOBALS: deleting SlaveInfo global memory

PC_DELETEGLOBALS: deleting ErrorInfo global memory

PC_DELETEGLOBALS: deleting SessionInfo global memory

PC_DELETEGLOBALS: leaving with result: 0

PC_FREEOPERAREA: deallocating column item list

PC_FREEITEMLIST: entering

PC_FREEITEMLIST: deallocating list of columns

PC_FREEITEMLIST: deallocating itemname address: 0x18dc448

PC_FREEITEMLIST: deallocating item list address: 0x18db980

PC_FREEITEMLIST: deallocating itemname address: 0x1890bb0

PC_FREEITEMLIST: deallocating item list address: 0x18db9c0

PC_FREEITEMLIST: deallocating itemname address: 0x1890bc0

PC_FREEITEMLIST: deallocating item list address: 0x18dba00

PC_FREEITEMLIST: deallocating itemname address: 0x18dd9e0

PC_FREEITEMLIST: deallocating item list address: 0x18dba40

PC_FREEITEMLIST: deallocating itemname address: 0x18dd9f0

PC_FREEITEMLIST: deallocating item list address: 0x18dba80

PC_FREEITEMLIST: deallocating itemname address: 0x18dc460

PC_FREEITEMLIST: deallocating item list address: 0x18dbac0

PC_FREEITEMLIST: deallocating itemname address: 0x18dc478

PC_FREEITEMLIST: deallocating item list address: 0x18dbb00

PC_FREEITEMLIST: deallocating itemname address: 0x18dc490

PC_FREEITEMLIST: deallocating item list address: 0x18dbb40

PC_FREEITEMLIST: deallocating itemname address: 0x18dc4a8

PC_FREEITEMLIST: deallocating item list address: 0x18dbb80

PC_FREEITEMLIST: deallocating itemname address: 0x18dc4c0

PC_FREEITEMLIST: deallocating item list address: 0x18dbbc0

PC_FREEITEMLIST: deallocating itemname address: 0x18dc4d8

PC_FREEITEMLIST: deallocating item list address: 0x18dbc00

PC_FREEITEMLIST: deallocating itemname address: 0x18dc4f0

PC_FREEITEMLIST: deallocating item list address: 0x18dbc40

PC_FREEITEMLIST: item list header is now: 0x0

PC_FREEITEMLIST: leaving

PC_FREEOPERAREA: deallocating item list header at: 0x18db980

PC_FREEOPERAREA: deallocating table list

PC_FREEOPERAREA: deallocating DML list

PC_FREEOPERAREA: deallocating TraceOption buffer

PC_FREEOPERAREA: deallocating TraceOption buffer at: 0x18dd4e8

PC_FREEOPERAREA: deallocating PrivateLog buffer

PC_FREEOPERAREA: deallocating ConsoleInfo buffer

PC_FREEOPERAREA: deallocating ConsoleInfo buffer at: 0x18dcfa0

PC_FREEOPERAREA: deallocating ErrorInfo buffer

PC_FREEOPERAREA: deallocating ErrorInfo buffer at: 0x18dd1b0

PC_FREEOPERAREA: deallocating notify_area buffer

PC_FREEOPERAREA: deallocating notify_area buffer at: 0x18db940

PC_FREEOPERAREA: deallocating OperCmdID buffer

PC_FREEOPERAREA: deallocating glblmsg

PC_FREEOPERAREA: deallocating glblmsg at: 0x29f0020

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0

file_reader: TPT19221 Total files processed: 0.

Job step MAIN_STEP terminated (status 12)

Job subhedas terminated (status 12)

Total available memory:          10000000

Largest allocable area:          10000000

Memory use high water mark:         63592

Free map size:                       1024

Free map use high water mark:          27

Free list use high water mark:          0