tbuild, failures of EXPORT operator on linux

Tools
Enthusiast

tbuild, failures of EXPORT operator on linux

The EXPORT operator job ran successfully on windows by TTU13.10. However failed on Linux same TTU version. Does anyone face the similar issue? I do think it's teradata bug.

============= Error =================
Teradata Parallel Transporter Export Operator Version 13.10.00.03
myexport: private log not specified
myfile: TPT19222 Operator instance 1 processing file '/build/file1.dat'.
myexport: connecting sessions
TPT_INFRA: TPT02345: Error: Cannot create column schema, status = Schema Error
myexport: TPT12111: Error 44 creating column schema
myexport: disconnecting sessions
myexport: Total processor time used = '0.07 Second(s)'
myexport: Start : Tue Sep 21 01:31:46 2010
myexport: End : Tue Sep 21 01:31:51 2010
TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

TPT_INFRA: TPT01037: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) core dumped

============ script =============

USING CHARACTER SET UTF16
DEFINE JOB TTU1310_TEST(
DEFINE SCHEMA testSchema(
C0_ CHAR(20),
C1_ INT,
C2_ INT,
C3_ CHAR(20),
C4_ CHAR(30));

DEFINE OPERATOR myfile
TYPE DATACONNECTOR CONSUMER
SCHEMA testSchema
ATTRIBUTES(
VARCHAR FileName='./file1.dat',
VARCHAR Format='Binary',
VARCHAR OpenMode='Write',
VARCHAR IndicatorMode = 'Y'
);
DEFINE OPERATOR myexport
TYPE EXPORT
SCHEMA testSchema
ATTRIBUTES(
VARCHAR TdpId='xx.xx.xx.xx',
VARCHAR DateForm='AnsiDate',
VARCHAR UserName='xxxx',
VARCHAR UserPassword='xxxx',
VARCHAR SelectStmt = 'SELECT "MYSRC"."TDATE" , "MYSRC"."ID" , ( "MYSRC"."ID" + 1) , "MYSRC"."TDATE" , "MYSRC"."TTIME" FROM "I052093"."MYSRC" "MYSRC" ;'
);

APPLY TO OPERATOR (myfile) SELECT * FROM OPERATOR (myexport););
13 REPLIES
Enthusiast

Re: tbuild, failures of EXPORT operator on linux

Can you execute the job again with TraceLevel ALL, and post the log of export operator please ?
Enthusiast

Re: tbuild, failures of EXPORT operator on linux

Please see the TraceLevel='ALL' log below.
I saw TPT complaint invalid tdate. MYSRC.TDATE is DATE type. I am using 'AnsiDate'. It should be converted to CHAR(20). The job works perfect with TTU 13.0 on both windows and Suse 11. It runs good with TTU 13.10 on windows, but fails on Suse 11.

TPT_INFRA: TPT02205: Error: Value length conflicts with its data type: status = Length Error
TPT_INFRA: TPT02201: Error: Column 'tdate' has an invalid length or type
TPT_INFRA: TPT02345: Error: Cannot create column schema, status = Schema Error

===============
DEFINE OPERATOR myexport
TYPE EXPORT
SCHEMA testSchema
ATTRIBUTES(
VARCHAR TraceLevel='ALL',
VARCHAR PrivateLogName='/build/rogerc/log/myexport.txt',
VARCHAR TdpId='xx.xx.xx.xx',
VARCHAR DateForm='AnsiDate',
VARCHAR UserName='xxxx',
VARCHAR UserPassword='xxxx',
VARCHAR SelectStmt = 'SELECT "MYSRC"."TDATE" , "MYSRC"."ID" , ( "MYSRC"."ID" + 1) , "MYSRC"."TDATE" , "MYSRC"."TTIME" FROM "I052093"."MYSRC" "MYSRC" ;'
);

=============================
rogerc@suse11:/build/rogerc/scripts> tlogview -l /opt/teradata/client/13.10/tbuild/logs/TTU1310_TEST-26.out
TPT_INFRA: TPT04101: Warning: TMSM failed to initialize
Found CheckPoint file: /opt/teradata/client/13.10/tbuild/checkpoint/TTU1310_TESTLVCP
This is a restart job; it restarts at step MAIN_STEP.
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 DataConnector Version 13.10.00.02
myfile Instance 1 is not generating a private log report.
Teradata Parallel Transporter Export Operator Version 13.10.00.03
myexport: private log specified: /build/rogerc/log/myexport.txt-1
myfile: TPT19007 DataConnector Consumer operator Instances: 1
myfile: TPT19003 ECI operator ID: myfile-25745
myfile: TPT19222 Operator instance 1 processing file '/build/rchen/ds260/dataservices/log/BulkReader/file1.dat'.
myexport: connecting sessions
TPT_INFRA: TPT02205: Error: Value length conflicts with its data type: status = Length Error
TPT_INFRA: TPT02201: Error: Column 'tdate' has an invalid length or type
TPT_INFRA: TPT02345: Error: Cannot create column schema, status = Schema Error
myexport: TPT12111: Error 44 creating column schema
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
myexport: disconnecting sessions
myexport: Total processor time used = '0.06 Second(s)'
myexport: Start : Thu Sep 23 19:36:51 2010
myexport: End : Thu Sep 23 19:36:55 2010
TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

TPT_INFRA: TPT01037: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) core dumped

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
myfile: TPT19221 Total files processed: 0.
Job step MAIN_STEP terminated (status 12)
Job TTU1310_TEST terminated (status 12)
Total available memory: 10002340
Largest allocable area: 10002340
Memory use high water mark: 45248
Free map size: 1024
Free map use high water mark: 13
Free list use high water mark: 0
Enthusiast

Re: tbuild, failures of EXPORT operator on linux

TraceLevel='ALL' logs
=================
TPT_INFRA: TPT04101: Warning: TMSM failed to initialize
Found CheckPoint file: /opt/teradata/client/13.10/tbuild/checkpoint/TTU1310_TESTLVCP
This is a restart job; it restarts at step MAIN_STEP.
Teradata Parallel Transporter Executor Version 13.10.00.02
Teradata Parallel Transporter Coordinator Version 13.10.00.02
Teradata Parallel Transporter Executor Version 13.10.00.02
Teradata Parallel Transporter DataConnector Version 13.10.00.02
myfile Instance 1 is not generating a private log report.
myfile: TPT19007 DataConnector Consumer operator Instances: 1
PC_GETOPERATTRS: *************************************************
myfile: TPT19003 ECI operator ID: myfile-5627
PC_GETOPERATTRS: entering handle: 0x8111a38
PC_GETOPERATTRS: MyOperatorName: 'myexport'
PC_GETOPERATTRS: MyOperatorType: 1 (Prod=1, Cons=2, Stand=5)
PC_GETOPERATTRS: Instance number: 1
PC_GETOPERATTRS: Max instances: 1
PC_GETOPERATTRS: RestartMode flag: 0
PC_GETOPERATTRS: Trace Level: 0x1f
PC_GETOPERATTRS: PublicLog Handle: 0x8111af0
PC_GETOPERATTRS: PrivateLog Handle: 0x0
PC_GETOPERATTRS: bytes for glblmsg: 2097152
PC_GETOPERATTRS: size of oper_desc: 300
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_CharSetDefault'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 1
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: character set is default: 'F'
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_CharSetId'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 5
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: character set: 'UTF16'
PC_GETOPERATTRS: UTF16 mode: 1
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_Checkpoint'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 4
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: checkpoint value: 0
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'DumpBytes'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'DumpBytes' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_APImode'
myfile: TPT19222 Operator instance 1 processing file './file1.dat'.
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'SYSTEM_APImode' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: *************************************************
PC_GETOPERATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'LogSQL'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'LogSQL' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETOPERATTRS: *************************************************
PC_INITOPERATOR: output starts now (already entered)
PC_GETPLATFORMENDIAN: entering
PC_GETPLATFORMENDIAN: Platform_Endian default is LITTLE endian
PC_GETPLATFORMENDIAN: leaving
Teradata Parallel Transporter Export Operator Version 13.10.00.03
myexport: private log not specified
PC_CREATEGLOBALS: entering
PC_CREATEGLOBALS: creating slave global memory
PC_CREATEGLOBALS: creating error global memory
PC_CREATEGLOBALS: initializing slave memory for instance: 1
PC_CREATEGLOBALS: initializing error memory for instance: 1
PC_CREATEGLOBALS: creating session global memory
PC_CREATEGLOBALS: initializing session global memory
PC_CREATEGLOBALS: leaving with result: 0

===================================================================
= =
= TERADATA PARALLEL TRANSPORTER =
= =
= EXPORT OPERATOR VERSION 13.10.00.03 =
= =
= OPERATOR SUPPORT LIBRARY VERSION 13.10.00.02 =
= =
= COPYRIGHT 2001-2010, TERADATA CORPORATION. ALL RIGHTS RESERVED. =
= =
===================================================================

**** 21:17:16 Processing starting at: Thu Sep 23 21:17:16 2010
PC_SHOWVERSION: entering
PC_SHOWVERSION: operator name: Export

===================================================================
= =
= Module Identification =
= =
===================================================================

PC_SHOWVERSION: system name: 'Linux'
PC_SHOWVERSION: node name: 'vanpglnxc26b5'
PC_SHOWVERSION: release: '2.6.27.19-5-default'
PC_SHOWVERSION: version: '#1 SMP 2009-02-28 04:40:21 +0100'
PC_SHOWVERSION: machine: 'x86_64'
Export Operator for Linux release 2.6.27.19-5-default on vanpglnxc26b5
PC_SHOWVERSION: module id: 'ExportMain', module vers: '13.10.00.09'
ExportMain : 13.10.00.09
PC_SHOWVERSION: module id: 'ExportCLI', module vers: '13.10.00.08'
ExportCLI : 13.10.00.08
PC_SHOWVERSION: module id: 'ExportUtil', module vers: '13.10.00.01'
ExportUtil : 13.10.00.01
PC_SHOWVERSION: module id: 'PcomCLI', module vers: '13.10.00.12'
PcomCLI : 13.10.00.12
PC_SHOWVERSION: module id: 'PcomMBCS', module vers: '13.00.00.02'
PcomMBCS : 13.00.00.02
PC_SHOWVERSION: module id: 'PcomMsgs', module vers: '13.01.00.07'
PcomMsgs : 13.01.00.07
PC_SHOWVERSION: module id: 'PcomNtfy', module vers: '13.00.00.03'
PcomNtfy : 13.00.00.03
PC_SHOWVERSION: module id: 'PcomPx', module vers: '13.10.00.11'
PcomPx : 13.10.00.11
PC_SHOWVERSION: module id: 'PcomUtil', module vers: '13.10.00.07'
PcomUtil : 13.10.00.07
PXICU : 13.10.00.02
TDICU : 13.10.00.00
PC_SHOWVERSION: leaving
PC_GETSCHEMAHANDLE: entering
PC_GETSCHEMAHANDLE: schema handle: 0x80fc4fc
PC_GETSCHEMAHANDLE: leaving
PC_GETCOLUMNSCHEMA: entering
PC_GETCOLUMNSCHEMA: address of list: 0x80fe598
PC_GETCOLUMNSCHEMA: number of columns: 5
PC_GETCOLUMNSCHEMA: received column handle: 0x80fe574
PC_GETCOLUMNSCHEMA: received column handle: 0x81038ec
PC_GETCOLUMNSCHEMA: received column handle: 0x810794c
PC_GETCOLUMNSCHEMA: received column handle: 0x810b9ac
PC_GETCOLUMNSCHEMA: received column handle: 0x810fa0c
PC_GETCOLUMNSCHEMA: allocated item list at: 0x811c988
PC_GETCOLUMNSCHEMA: Name, Type, Size: 'C0_', 5, 20
PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0
PC_GETCOLUMNSCHEMA: attempting to malloc 4 bytes
PC_VALIDATECOLTYPE: entering with column type: 5
PC_GETCOLUMNSCHEMA: allocated item list at: 0x811c9d8
PC_GETCOLUMNSCHEMA: Name, Type, Size: 'C1_', 1, 4
PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0
PC_GETCOLUMNSCHEMA: attempting to malloc 4 bytes
PC_VALIDATECOLTYPE: entering with column type: 1
PC_GETCOLUMNSCHEMA: allocated item list at: 0x811ca28
PC_GETCOLUMNSCHEMA: Name, Type, Size: 'C2_', 1, 4
PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0
PC_GETCOLUMNSCHEMA: attempting to malloc 4 bytes
PC_VALIDATECOLTYPE: entering with column type: 1
PC_GETCOLUMNSCHEMA: allocated item list at: 0x811ca78
PC_GETCOLUMNSCHEMA: Name, Type, Size: 'C3_', 5, 20
PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0
PC_GETCOLUMNSCHEMA: attempting to malloc 4 bytes
PC_VALIDATECOLTYPE: entering with column type: 5
PC_GETCOLUMNSCHEMA: allocated item list at: 0x811cac8
PC_GETCOLUMNSCHEMA: Name, Type, Size: 'C4_', 5, 30
PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0
PC_GETCOLUMNSCHEMA: attempting to malloc 4 bytes
PC_VALIDATECOLTYPE: entering with column type: 5
PC_GETCOLUMNSCHEMA:
PC_GETCOLUMNSCHEMA: Final Column List
PC_GETCOLUMNSCHEMA: -----------------
PC_GETCOLUMNSCHEMA: Address: 0x811c988, next: 0x811c9d8
PC_GETCOLUMNSCHEMA: Address: 0x811c9d8, next: 0x811ca28
PC_GETCOLUMNSCHEMA: Address: 0x811ca28, next: 0x811ca78
PC_GETCOLUMNSCHEMA: Address: 0x811ca78, next: 0x811cac8
PC_GETCOLUMNSCHEMA: Address: 0x811cac8, next: 0x0
PC_GETCOLUMNSCHEMA:
PC_GETCOLUMNSCHEMA: itemhdr address: 0x811c988

PC_OUTCOLLIST: ========================================
PC_OUTCOLLIST: 1. Field Name: C0_
PC_OUTCOLLIST: Type: CHAR
PC_OUTCOLLIST: Size: 20
PC_OUTCOLLIST: Prec: 0
PC_OUTCOLLIST: Scale: 0
PC_OUTCOLLIST:
PC_OUTCOLLIST: 2. Field Name: C1_
PC_OUTCOLLIST: Type: INTEGER
PC_OUTCOLLIST: Size: 4
PC_OUTCOLLIST: Prec: 0
PC_OUTCOLLIST: Scale: 0
PC_OUTCOLLIST:
PC_OUTCOLLIST: 3. Field Name: C2_
PC_OUTCOLLIST: Type: INTEGER
PC_OUTCOLLIST: Size: 4
PC_OUTCOLLIST: Prec: 0
PC_OUTCOLLIST: Scale: 0
PC_OUTCOLLIST:
PC_OUTCOLLIST: 4. Field Name: C3_
PC_OUTCOLLIST: Type: CHAR
PC_OUTCOLLIST: Size: 20
PC_OUTCOLLIST: Prec: 0
PC_OUTCOLLIST: Scale: 0
PC_OUTCOLLIST:
PC_OUTCOLLIST: 5. Field Name: C4_
PC_OUTCOLLIST: Type: CHAR
PC_OUTCOLLIST: Size: 30
PC_OUTCOLLIST: Prec: 0
PC_OUTCOLLIST: Scale: 0
PC_OUTCOLLIST:
PC_OUTCOLLIST: There are 5 fields defined
PC_OUTCOLLIST: ========================================

PC_GETCOLUMNSCHEMA: leaving
PC_INITOPERATOR: latency flag is: 0
PC_INITOPERATOR: leaving
INITIATE: phase 1
INITMYOPERATOR: entering
INITMYOPERATOR: allocated private area at: 0x811cb48
INITMYOPERATOR: number of bytes allocated: 124
INITMYOPERATOR: allocated event area at: 0x811cbc8
INITMYOPERATOR: leaving
PC_INITCLIOPER: entering
PC_INITCLIAREA: entering
PC_INITCLIAREA: allocating CLI area, size: 1056
PC_INITCLIAREA: allocated CLI area, addr: 0x811cef0
PC_INITCLIAREA: allocated reqstr, addr: 0x811d318
PC_INITCLIAREA: allocated partition, addr: 0x811d720
PC_INITCLIAREA: allocated CharSet, addr: 0x811d738
PC_INITCLIAREA: opening UTF8 converter
PC_INITCLIAREA: allocated utf8_conv, addr: 0x811d760
PC_INITCLIAREA: opening ToU callback facility
PC_INITCLIAREA: opening FromU callback facility
PC_INITCLIAREA: leaving
PC_GETCLIATTRS: entering
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'TdpId'
PC_GETATTRIBUTE: alt attr: 'SYSTEM_DBMSExternalName'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 13
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: Tdp Id: '10.208.83.108'
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'UserName'
PC_GETATTRIBUTE: alt attr: 'SYSTEM_DBMSUserName'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 7
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: logon user id: 'I052093'
PC_GETCLIATTRS: *************************************************
PC_GETCLIATTRS: logon password:
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'AccountId'
PC_GETATTRIBUTE: alt attr: 'SYSTEM_DBMSAccountId'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'AccountId' not found
PC_GETATTRIBUTE: retrieving alternate: 'SYSTEM_DBMSAccountId'
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'WorkingDatabase'
PC_GETATTRIBUTE: alt attr: 'SYSTEM_DBMSWorkingDatabase'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'WorkingDatabase' not found
PC_GETATTRIBUTE: retrieving alternate: 'SYSTEM_DBMSWorkingDatabase'
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'TenacityHours'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'TenacityHours' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'TenacitySleep'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'TenacitySleep' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'MaxSessions'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'MaxSessions' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'MinSessions'
PC_GETATTRIBUTE: mandatory: 0
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 length: 8
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
PC_GETCLIATTRS: DateForm: 'ANSIDATE'
PC_GETCLIATTRS: ANSI_date flag: 1
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: 0x811d868
PC_INITCLI: DBCHINI returns charset string: 'ASCII '
PC_INITCLI: DBCHINI returns charset type: ' '
PC_GETDBSLIMITS: entering
PC_GETDBSLIMITS: calling DBCHQE for CLI Limits
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 35
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETDBSLIMITS: MaxRequestBytes: 1048500
PC_GETDBSLIMITS: calling DBCHQE for DBS Limits
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 36
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETDBSLIMITS: MaxRowBytes: 64768
PC_GETDBSLIMITS: MaxLobBytes: 2097088000
PC_GETDBSLIMITS: MaxObjectNameChars: 30
PC_GETDBSLIMITS: MaxColinTbl: 2048
PC_GETDBSLIMITS: MaxTblinSel: 64
PC_GETDBSLIMITS: MaxColinSel: 65535
PC_GETDBSLIMITS: MaxColGrpBy: 191
PC_GETDBSLIMITS: MaxColOrdrBy: 16
PC_GETDBSLIMITS: MaxCharLiteralChars: 31000
PC_GETDBSLIMITS: MaxBinLiteralChars: 62000
PC_GETDBSLIMITS: MaxColBytes: 64000
PC_GETDBSLIMITS: MaxCharChars: 64000
PC_GETDBSLIMITS: MaxVarcharChars: 64000
PC_GETDBSLIMITS: MaxByteBytes: 64000
PC_GETDBSLIMITS: MaxVarbyteBytes: 64000
PC_GETDBSLIMITS: MaxDecimal: 38
PC_GETDBSLIMITS: MaxTimeScale: 6
PC_GETDBSLIMITS: MaxTimeStampScale: 6
PC_GETDBSLIMITS: MaxFldsUsingRow: 2547
PC_GETDBSLIMITS: MaxParamsInRequest: 2547
PC_GETDBSLIMITS: leaving with return code: 0
PC_GETMECHANISM: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 32
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETMECHANISM: DBCHQE returns: 0
PC_GETMECHANISM: mechanisms not returned: 1
PC_GETMECHANISM: mechanisms returned: 1
PC_GETMECHANISM: logon mechanism is supported
PC_GETMECHANISM: leaving with result: 0
PC_GETRESULTSUMMARY: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 29
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETRESULTSUMMARY: DBCHQE flag is: 'N'
PC_GETRESULTSUMMARY: result summary not supported by DBS
PC_GETRESULTSUMMARY: leaving with result: 0
PC_GETBIGINTSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 39
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETBIGINTSUPPORT: DBCHQE flag is: 'Y'
PC_GETBIGINTSUPPORT: setting BIGINT flag to TRUE
PC_GETBIGINTSUPPORT: leaving with result: 0
PC_GETTASMSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 23
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETTASMSUPPORT: DBCHQE flag is: 'N'
PC_GETTASMSUPPORT: TASM support flag is FALSE
PC_GETTASMSUPPORT: leaving with result: 0
PC_INITCLI: leaving
PC_INITCLICHARSET: entering
PC_INITCLICHARSET: charset attribute was set
PC_SETCLICHARSET: entering with charset: 'UTF16'
PC_SETCLICHARSET: character set is a name
PC_SETCLICHARSET: character set type: 'N'
PC_SETCLICHARSET: character set is : 'UTF16'
PC_SETCLICHARSET: character set type: 'N'
PC_SETCLICHARSET: character set is : 'UTF16 '
PC_SETCLICHARSET: leaving
PC_INITCLICHARSET: default charset: 'UTF16 '
PC_INITCLICHARSET: default chartype: 'N'
PC_INITCLICHARSET: leaving
PC_GETCLIVERSION: entering
PC_GETCLIVERSION: calling DBCHQE for CLI version id
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 0
PC_ISSUEDBCHQE: qepItem: 9
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: not using TDP ID or SESS ID for this query
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
CLIv2 : 13.10.00.00
PC_GETCLIVERSION: leaving with return code: 0
PC_CHECKANSIDATE: entering
PC_CHECKANSIDATE: checking if 'C0_' is an ANSI Date field
PC_CHECKANSIDATE: checking if 'C1_' is an ANSI Date field
PC_CHECKANSIDATE: checking if 'C2_' is an ANSI Date field
PC_CHECKANSIDATE: checking if 'C3_' is an ANSI Date field
PC_CHECKANSIDATE: checking if 'C4_' is an ANSI Date field
PC_CHECKANSIDATE: leaving
PC_INITCLIOPER: leaving
PX_INITIATE: EOD = 0
GETMYATTRIBUTES: entering
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'BlockSize'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'BlockSize' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: **********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'OutLimit'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'OutLimit' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: **********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'DateForm'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 8
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: token = ANSIDATE
GETMYATTRIBUTES: deallocating DateForm temp ptr at: 135445336
GETMYATTRIBUTES: ANSI flag: 1
GETMYATTRIBUTES: **********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SelectStmt'
PC_GETATTRIBUTE: mandatory: 1
PC_GETATTRIBUTE: attribute length: 137
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: SELECT request: 'SELECT "MYSRC"."TDATE" , "MYSRC"."ID" , ( "MYSRC"."ID" + 1) , "MYSRC"."TDATE" , "MYSRC"."TTIME" FROM "I052093"."MYSRC" "MYSRC" ;'
GETMYATTRIBUTES: **********************************************
CHECKORDERBY: entering
CHECKORDERBY: length of select request : 137
CHECKORDERBY: select request : SELECT "MYSRC"."TDATE" , "MYSRC"."ID" , ( "MYSRC"."ID" + 1) , "MYSRC"."TDATE" , "MYSRC"."TTIME" FROM "I052093"."MYSRC" "MYSRC" ;
CHECKORDERBY: allocated temp ptr at: 135428464
CHECKORDERBY: copy of selectptr : SELECT "MYSRC"."TDATE" , "MYSRC"."ID" , ( "MYSRC"."ID" + 1) , "MYSRC"."TDATE" , "MYSRC"."TTIME" FROM "I052093"."MYSRC" "MYSRC" ;
CHECKORDERBY: copy of selectptr after uppercase: SELECT "MYSRC"."TDATE" , "MYSRC"."ID" , ( "MYSRC"."ID" + 1) , "MYSRC"."TDATE" , "MYSRC"."TTIME" FROM "I052093"."MYSRC" "MYSRC" ;
CHECKORDERBY: token = SELECT
CHECKORDERBY: token = "MYSRC"."TDATE"
CHECKORDERBY: token = ,
CHECKORDERBY: token = "MYSRC"."ID"
CHECKORDERBY: token = ,
CHECKORDERBY: token = (
CHECKORDERBY: token = "MYSRC"."ID"
CHECKORDERBY: token = +
CHECKORDERBY: token = 1)
CHECKORDERBY: token = ,
CHECKORDERBY: token = "MYSRC"."TDATE"
CHECKORDERBY: token = ,
CHECKORDERBY: token = "MYSRC"."TTIME"
CHECKORDERBY: token = FROM
CHECKORDERBY: token = "I052093"."MYSRC"
CHECKORDERBY: token = "MYSRC"
CHECKORDERBY: deallocating temp ptr at: 135428464
CHECKORDERBY: order by clause? : 0
CHECKORDERBY: exiting
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'MaxDecimalDigits'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'MaxDecimalDigits' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'IgnoreMaxDecimalDigits'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'IgnoreMaxDecimalDigits' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: IgnoreMaxDecimalDigits: 0
GETMYATTRIBUTES: *************************************************
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SpoolMode'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'SpoolMode' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: SpoolMode: 1
GETMYATTRIBUTES: leaving
PC_LOGJOBMETADATA: entering
PC_LOGOPERIDMETADATA: entering
PC_LOGOPERIDMETADATA: leaving
PC_LOGJOBMETADATA: leaving
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_INITNOTIFY: entering
PC_INITNOTIFY: address of event table: 0xf71860e0
PC_INITNOTIFY: old event, new event: 0 --> 0
PC_INITNOTIFY: old event, new event: 1 --> 1
PC_INITNOTIFY: old event, new event: 9 --> 9
PC_INITNOTIFY: old event, new event: 10 --> 10
PC_INITNOTIFY: old event, new event: 11 --> 11
PC_INITNOTIFY: old event, new event: 12 --> 12
PC_INITNOTIFY: old event, new event: 31 --> 31
PC_INITNOTIFY: old event, new event: 32 --> 32
PC_INITNOTIFY: old event, new event: 33 --> 33
PC_INITNOTIFY: old event, new event: 34 --> 34
PC_INITNOTIFY: old event, new event: 35 --> 35
PC_INITNOTIFY: old event, new event: 36 --> 36
PC_INITNOTIFY: old event, new event: 37 --> 37
PC_INITNOTIFY: old event, new event: 38 --> 38
PC_INITNOTIFY: old event, new event: 39 --> 39
PC_INITNOTIFY: old event, new event: 40 --> 40
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'NotifyMethod'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'NotifyMethod' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
PC_INITNOTIFY: Notify method: 0
PC_INITNOTIFY: no method specified. Leaving.
PC_OUTPUTATTRS: entering

===================================================================
= =
= Attribute Definitions =
= =
===================================================================

**** 21:17:16 Options in effect for this job:
OperatorType: Producer
Instances: 1
Character set: 'UTF16'
Checkpoint: No checkpoint in effect
Notify: Not enabled
Trace Option: 'ALL'
Trace Output: Enabled
PC_OUTPUTATTRS: leaving
PC_OUTPUTCLIATTRS: entering
PC_OUTPUTCLIATTRS: leaving
Tenacity: 4 hour limit to successfully connect
Sleep: 6 minute(s) between connect retries
Date format: ANSIDATE
Blocksize: Maximum allowable
OutLimit: No limit in effect
PC_SHOWLAYOUT: entering

===================================================================
= =
= Column/Field Definition =
= =
===================================================================

Column Name Offset Length Type
============================== ====== ====== ========================
C0_ 0 20 CHAR
C1_ 20 4 INTEGER
C2_ 24 4 INTEGER
C3_ 28 20 CHAR
C4_ 48 30 CHAR
============================== ====== ====== ========================
INDICATOR BYTES NEEDED: 1
EXPECTED RECORD LENGTH: 79
PC_SHOWLAYOUT: leaving
PX_INITIATE: phase 2
PC_DOLOGONMAIN: entering

===================================================================
= =
= Control Session Connection =
= =
===================================================================

myexport: connecting sessions
**** 21:17:16 Connecting to RDBMS: '10.208.83.108'
**** 21:17:16 Connecting with UserId: 'I052093'
PC_BUILDLOGONSTR: entering
PC_BUILDLOGONSTR: allocating buffer for UTF16 logon string
PC_BUILDLOGONSTR: allocated UTF16 logon string at: 0x8127970
PC_BUILDLOGONSTR: allocated 56 bytes: 0
PC_BUILDLOGONSTR: converting logon string to UTF16
PC_BUILDLOGONSTR: bytes allocated for UTF16 Logon string: 56
PC_BUILDLOGONSTR: UTF16 logon string allocated address: 0x8127970
PC_BUILDLOGONSTR: leaving
PC_DOREQUEST: entering
PC_ISSUELOGONMAIN
PC_ISSUELOGONMAIN: entering
PC_ISSUELOGONMAIN: address of Main SQL DBCAREA: 0x81279b0
PC_ISSUELOGONMAIN: ****************************
PC_ISSUELOGONMAIN: PREPARING MAIN SQL SESSION *
PC_ISSUELOGONMAIN: ****************************
PC_INITDBCAREA: entering
PC_INITDBCAREA: date_form init to: D
PC_INITDBCAREA: max_parcel init to: O
PC_INITDBCAREA: data_encryption init to: N
PC_INITDBCAREA: date_form set to: A
PC_INITDBCAREA: max_parcel set to: O
PC_INITDBCAREA: data_encryption set to: N
PC_INITDBCAREA: statemnt_status set to: O
PC_INITDBCAREA: max dec digits set to: 0
PC_INITDBCAREA: workload pointer: 'TPTEXP'
PC_INITDBCAREA: workload length: 6
PC_INITDBCAREA: leaving
PC_ISSUELOGONMAIN: Main SQL session charset: 'UTF16 '
PC_ISSUELOGONMAIN: Main SQL session chartype: 'N'
PC_ISSUELOGONMAIN: logging on Main SQL Session
PC_CONNECTSESSION: entering
PC_CONNECTSESSION: leaving with return code: 0
PC_ISSUELOGONMAIN: Main input session/request id: 7, 1
PC_ISSUELOGONMAIN: Main output session/request id: 7, 1
PC_FETCHRESP: entering, expecting flavor: 8
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 8
PC_ERRORSET: Success!, Activity Count: 0
PC_ERRORSET: stmnt #: 0
PC_ERRORSET: field ct: 0
PC_ERRORSET: act type: 0
PC_ERRORSET: warningcode: 0
PC_ERRORSET: warning len: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 89
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 89
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 12
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 12
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_ENDREQUEST: entering
PC_ENDREQUEST: leaving
PC_ISSUELOGONMAIN: # of SQL sessions connected: 1
PC_ISSUELOGONMAIN: placing the following items in global memory
PC_ISSUELOGONMAIN: LSN number is: 5707
PC_UPDATESESSIONINFO: **********************************************
PC_UPDATESESSIONINFO: entering
PC_UPDATESESSIONINFO: after read
PC_UPDATESESSIONINFO: LSN number is: 0
PC_UPDATESESSIONINFO: Maximum field size is: 0
PC_UPDATESESSIONINFO: Maximum buffer size is: 0
PC_UPDATESESSIONINFO: Maximum message size is: 0
PC_UPDATESESSIONINFO: Action Code is: 0
PC_UPDATESESSIONINFO: Number of DMLs is: 0
PC_UPDATESESSIONINFO: DBS Upsert Support: 0
PC_UPDATESESSIONINFO: DataEncryption Support: 0
PC_UPDATESESSIONINFO: Session charset type: ' '
PC_UPDATESESSIONINFO: Session character set: ' '
PC_UPDATESESSIONINFO: updating LSN field
PC_UPDATESESSIONINFO: before write
PC_UPDATESESSIONINFO: LSN number is: 5707
PC_UPDATESESSIONINFO: Maximum field size is: 0
PC_UPDATESESSIONINFO: Maximum buffer size is: 0
PC_UPDATESESSIONINFO: Maximum message size is: 0
PC_UPDATESESSIONINFO: Action Code is: 0
PC_UPDATESESSIONINFO: Number of DMLs is: 0
PC_UPDATESESSIONINFO: DBS Upsert support: 0
PC_UPDATESESSIONINFO: DataEncryption Support: 0
PC_UPDATESESSIONINFO: Session charset type: ' '
PC_UPDATESESSIONINFO: Session character set: ' '
PC_UPDATESESSIONINFO: leaving with result: 0
PC_UPDATESESSIONINFO: **********************************************
PC_SENDTASMQUERYBAND: entering
PC_SENDTASMQUERYBAND: TASM is either not supported or not needed
PC_SENDTASMQUERYBAND: leaving
PC_SENDQUERYBAND: entering
PC_SENDQUERYBAND: no query band information has been provided
PC_SENDQUERYBAND: leaving
PC_ISSUELOGONMAIN: leaving
PC_DOREQUEST: leaving successfully
PC_GETDEFAULTDATABASE: entering
PC_PROCESSREQ: entering
PC_INITIATEREQ: entering with request: 'HELP SESSION;'
PC_INITIATEREQ: request length: 13
PC_INITIATEREQ: Using length: 0
PC_INITIATEREQ: allocating buffer for UTF16 request
PC_INITIATEREQ: allocated buffer for UTF16 request at: 0x812ac28
PC_INITIATEREQ: converting request to UTF16
PC_INITIATEREQ: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 8
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 8
PC_ERRORSET: Success!, Activity Count: 1
PC_ERRORSET: stmnt #: 1
PC_ERRORSET: field ct: 46
PC_ERRORSET: act type: 50
PC_ERRORSET: warningcode: 0
PC_ERRORSET: warning len: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_PROCESSREQ: leaving with result: 0
PC_ISREQUESTDEADLOCKED: entering
PC_ISREQUESTDEADLOCKED: CLI/DBS result 0 is not a deadlock error
PC_ISREQUESTDEADLOCKED: leaving
PC_FETCHRESP: entering, expecting flavor: 71
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 71
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_GETDEFAULTDATABASE: parcel flavor: 71
PC_GETDEFAULTDATABASE: number of fields(HELP SESSION): 46
PC_GETDEFAULTDATABASE: allocating array(HELP SESSION): 184 bytes
PC_GETDEFAULTDATABASE: allocated size_array at: 0x812a8a0
PC_GETDEFAULTDATABASE: Type 1: 448, 14
PC_GETDEFAULTDATABASE: Type 2: 448, 6
PC_GETDEFAULTDATABASE: Type 3: 452, 16
PC_GETDEFAULTDATABASE: Type 4: 452, 16
PC_GETDEFAULTDATABASE: Type 5: 448, 14
PC_GETDEFAULTDATABASE: Type 6: 448, 30
PC_GETDEFAULTDATABASE: Type 7: 448, 60
PC_GETDEFAULTDATABASE: Type 8: 448, 16
PC_GETDEFAULTDATABASE: Type 9: 448, 22
PC_GETDEFAULTDATABASE: Type 10: 448, 12
PC_GETDEFAULTDATABASE: Type 11: 448, 60
PC_GETDEFAULTDATABASE: Type 12: 452, 2
PC_GETDEFAULTDATABASE: Type 13: 452, 2
PC_GETDEFAULTDATABASE: Type 14: 452, 2
PC_GETDEFAULTDATABASE: Type 15: 452, 2
PC_GETDEFAULTDATABASE: Type 16: 452, 2
PC_GETDEFAULTDATABASE: Type 17: 448, 16
PC_GETDEFAULTDATABASE: Type 18: 448, 2
PC_GETDEFAULTDATABASE: Type 19: 448, 2
PC_GETDEFAULTDATABASE: Type 20: 448, 2
PC_GETDEFAULTDATABASE: Type 21: 448, 2
PC_GETDEFAULTDATABASE: Type 22: 448, 2
PC_GETDEFAULTDATABASE: Type 23: 448, 2
PC_GETDEFAULTDATABASE: Type 24: 448, 20
PC_GETDEFAULTDATABASE: Type 25: 448, 2
PC_GETDEFAULTDATABASE: Type 26: 448, 6
PC_GETDEFAULTDATABASE: Type 27: 448, 20
PC_GETDEFAULTDATABASE: Type 28: 448, 2
PC_GETDEFAULTDATABASE: Type 29: 448, 6
PC_GETDEFAULTDATABASE: Type 30: 448, 10
PC_GETDEFAULTDATABASE: Type 31: 448, 12
PC_GETDEFAULTDATABASE: Type 32: 448, 10
PC_GETDEFAULTDATABASE: Type 33: 448, 20
PC_GETDEFAULTDATABASE: Type 34: 448, 44
PC_GETDEFAULTDATABASE: Type 35: 448, 28
PC_GETDEFAULTDATABASE: Type 36: 448, 50
PC_GETDEFAULTDATABASE: Type 37: 448, 0
PC_GETDEFAULTDATABASE: Type 38: 448, 6
PC_GETDEFAULTDATABASE: Type 39: 448, 0
PC_GETDEFAULTDATABASE: Type 40: 452, 2
PC_GETDEFAULTDATABASE: Type 41: 448, 14
PC_GETDEFAULTDATABASE: Type 42: 452, 4
PC_GETDEFAULTDATABASE: Type 43: 448, 12
PC_GETDEFAULTDATABASE: Type 44: 448, 0
PC_GETDEFAULTDATABASE: Type 45: 448, 0
PC_GETDEFAULTDATABASE: Type 46: 448, 0
PC_GETDEFAULTDATABASE: number of indicator bytes: 6
PC_FETCHRESP: entering, expecting flavor: 10
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 10
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_GETDEFAULTDATABASE: field_len: 14
PC_GETDEFAULTDATABASE: converting default dbname from UTF16 to UTF8
PC_GETDEFAULTDATABASE: j: 7
PC__GETDEFAULTDATABASE: DefaultDatabase: 'I052093'
PC_FETCHRESP: entering, expecting flavor: 11
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 11
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 12
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 12
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_ENDREQUEST: entering
PC_ENDREQUEST: leaving
PC_GETDEFAULTDATABASE: freeing size_array at: 0x812a8a0
PC_GETDEFAULTDATABASE: leaving
PC_DOLOGONMAIN: leaving
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_DOLOGONAUX: entering
PC_DOREQUEST: entering
PC_ISSUELOGONAUX
PC_ISSUELOGONAUX: entering
PC_ISSUELOGONAUX: address of Aux SQL DBCAREA: 0x81296f0
PC_ISSUELOGONAUX: ***************************
PC_ISSUELOGONAUX: PREPARING AUX SQL SESSION *
PC_ISSUELOGONAUX: ***************************
PC_INITDBCAREA: entering
PC_INITDBCAREA: date_form init to: D
PC_INITDBCAREA: max_parcel init to: O
PC_INITDBCAREA: data_encryption init to: N
PC_INITDBCAREA: date_form set to: A
PC_INITDBCAREA: max_parcel set to: O
PC_INITDBCAREA: data_encryption set to: N
PC_INITDBCAREA: statemnt_status set to: O
PC_INITDBCAREA: max dec digits set to: 0
PC_INITDBCAREA: workload pointer: 'TPTEXP'
PC_INITDBCAREA: workload length: 6
PC_INITDBCAREA: leaving
PC_ISSUELOGONAUX: Aux SQL session charset: 'UTF16 '
PC_ISSUELOGONAUX: Aux SQL session chartype: 'N'
PC_ISSUELOGONAUX: logging on Auxiliary SQL Session
PC_CONNECTSESSION: entering
PC_CONNECTSESSION: leaving with return code: 0
PC_ISSUELOGONAUX: Aux input session/request id: 8, 1
PC_ISSUELOGONAUX: Aux output session/request id: 8, 1
PC_FETCHRESP: entering, expecting flavor: 8
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 8
PC_ERRORSET: Success!, Activity Count: 0
PC_ERRORSET: stmnt #: 0
PC_ERRORSET: field ct: 0
PC_ERRORSET: act type: 0
PC_ERRORSET: warningcode: 0
PC_ERRORSET: warning len: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 12
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 12
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_ENDREQUEST: entering
PC_ENDREQUEST: leaving
PC_ISSUELOGONAUX: # of SQL sessions connected: 2
PC_SENDTASMQUERYBAND: entering
PC_SENDTASMQUERYBAND: TASM is either not supported or not needed
PC_SENDTASMQUERYBAND: leaving
PC_SENDQUERYBAND: entering
PC_SENDQUERYBAND: no query band information has been provided
PC_SENDQUERYBAND: leaving
PC_ISSUELOGONAUX: leaving
PC_DOREQUEST: leaving successfully
PC_DOLOGONAUX: leaving
PC_GETDBSINFO: entering

===================================================================
= =
= Teradata Database Information =
= =
===================================================================

PC_GETDBSVERSION: entering
PC_GETDBSVERSION: calling DBCHQE for DBS version
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 34
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
**** 21:17:19 Teradata Database Version: '13.00.00.03 '
**** 21:17:19 Teradata Database Release: '13.00.00.03 '
PC_GETDBSVERSION: leaving with return code: 0
PC_GET1MREQ: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 21
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GET1MREQ: DBCHQE flag is: '1'
PC_GET1MREQ: leaving with result: 0
**** 21:17:19 Maximum request size supported: 1MB
PC_GETDBSINFO: User did not specify a Blocksize
PC_GETDBSINFO: Setting BlockSize to: 64330
PC_GETDBSINFO: maxbufsize is: 64330
PC_GETDBSINFO: current charset: 'UTF16 '
PC_GETDBSINFO: current chartype: 'N'
**** 21:17:19 Session character set: 'UTF16'
PC_GETNUMBEROFAMPS: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 10
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETNUMBEROFAMPS: DBCHQE AMP number is: 2
PC_GETNUMBEROFAMPS: leaving
**** 21:17:19 Total AMPs available: 2
PC_GET1MBRESPSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 20
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GET1MBRESPSUPPORT: DBCHQE flag is: 'Y'
PC_GET1MBRESPSUPPORT: setting 1M response flag to TRUE
PC_GET1MBRESPSUPPORT: leaving with result: 0
PC_GETIDCSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 23
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETIDCSUPPORT: DBCHQE flag is: 'Y'
PC_GETIDCSUPPORT: setting IDC flag to TRUE
PC_GETIDCSUPPORT: leaving with result: 0
PC_GETLOBSUPPORT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 18
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETLOBSUPPORT: DBCHQE flag is: 'Y'
PC_GETLOBSUPPORT: leaving with result: 0
PC_GETDATAENCRYPTION: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 1
PC_ISSUEDBCHQE: qepItem: 26
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using SESS ID for this query
PC_ISSUEDBCHQE: calling DBCHQE for session: 7
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETDATAENCRYPTION: DBCHQE flag is: 'Y'
PC_GETDATAENCRYPTION: data encryption is supported
**** 21:17:19 Data Encryption: supported
PC_GETDATAENCRYPTION: leaving with result: 0
PC_GETUDT: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 30
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETUDT: DBCHQE flag is: 'Y'
PC_GETUDT: DBS does support UDTs
PC_GETUDT: leaving with result: 0
PC_GETSTATEMENTINFO: entering
PC_ISSUEDBCHQE: entering
PC_ISSUEDBCHQE: UseTDP: 2
PC_ISSUEDBCHQE: qepItem: 38
PC_ISSUEDBCHQE: qepLevel: 0x81
PC_ISSUEDBCHQE: using TDP ID for this query
PC_ISSUEDBCHQE: my_cli->TdpId: '10.208.83.108'
PC_ISSUEDBCHQE: calling DBCHQE for TDP: '10.208.83.108'
PC_ISSUEDBCHQE: length of TDPid is: 13
PC_ISSUEDBCHQE: leaving with Supported flag: 1
PC_ISSUEDBCHQE: leaving with return code: 0
PC_GETSTATEMENTINFO: DBCHQE flag is: 'Y'
PC_GETSTATEMENTINFO: DBS supports StatementInfo
PC_GETSTATEMENTINFO: SupportStmtInfo set to: 0
PC_GETSTATEMENTINFO: leaving with result: 0
PC_UPDATESESSIONINFO: **********************************************
PC_UPDATESESSIONINFO: entering
PC_UPDATESESSIONINFO: after read
PC_UPDATESESSIONINFO: LSN number is: 5707
PC_UPDATESESSIONINFO: Maximum field size is: 0
PC_UPDATESESSIONINFO: Maximum buffer size is: 0
PC_UPDATESESSIONINFO: Maximum message size is: 0
PC_UPDATESESSIONINFO: Action Code is: 0
PC_UPDATESESSIONINFO: Number of DMLs is: 0
PC_UPDATESESSIONINFO: DBS Upsert Support: 0
PC_UPDATESESSIONINFO: DataEncryption Support: 0
PC_UPDATESESSIONINFO: Session charset type: ' '
PC_UPDATESESSIONINFO: Session character set: ' '
PC_UPDATESESSIONINFO: updating all fields
PC_UPDATESESSIONINFO: before write
PC_UPDATESESSIONINFO: LSN number is: 5707
PC_UPDATESESSIONINFO: Maximum field size is: 64000
PC_UPDATESESSIONINFO: Maximum buffer size is: 64330
PC_UPDATESESSIONINFO: Maximum message size is: 64260
PC_UPDATESESSIONINFO: Action Code is: 0
PC_UPDATESESSIONINFO: Number of DMLs is: 0
PC_UPDATESESSIONINFO: DBS Upsert support: 0
PC_UPDATESESSIONINFO: DataEncryption Support: 1
PC_UPDATESESSIONINFO: Session charset type: 'N'
PC_UPDATESESSIONINFO: Session character set: 'UTF16 '
PC_UPDATESESSIONINFO: leaving with result: 0
PC_UPDATESESSIONINFO: **********************************************
PC_GETDBSINFO: leaving
PX_INITIATE: Setting BlockSize to: 64330
**** 21:17:19 Blocksize for this job: 64330 bytes
GETCOLUMNINFO: entering
PC_FREEITEMLIST: entering
PC_FREEITEMLIST: deallocating list of columns
PC_FREEITEMLIST: deallocating itemname address: 0x811c9c8
PC_FREEITEMLIST: deallocating item list address: 0x811c988
PC_FREEITEMLIST: deallocating itemname address: 0x811ca18
PC_FREEITEMLIST: deallocating item list address: 0x811c9d8
PC_FREEITEMLIST: deallocating itemname address: 0x811ca68
PC_FREEITEMLIST: deallocating item list address: 0x811ca28
PC_FREEITEMLIST: deallocating itemname address: 0x811cab8
PC_FREEITEMLIST: deallocating item list address: 0x811ca78
PC_FREEITEMLIST: deallocating itemname address: 0x811cb08
PC_FREEITEMLIST: deallocating item list address: 0x811cac8
PC_FREEITEMLIST: item list header is now: 0x0
PC_FREEITEMLIST: leaving
GETCOLUMNINFO: deallocating item list header at: 0x811c988
GETCOLUMNDATA_STMTINFO: entering
GETCOLUMNDATA_STMTINFO: request is: 'SELECT "MYSRC"."TDATE" , "MYSRC"."ID" , ( "MYSRC"."ID" + 1) , "MYSRC"."TDATE" , "MYSRC"."TTIME" FROM "I052093"."MYSRC" "MYSRC" ;'
PC_PROCESSREQ: entering
PC_INITIATEREQ: entering with request: 'SELECT "MYSRC"."TDATE" , "MYSRC"."ID" , ( "MYSRC"."ID" + 1) , "MYSRC"."TDATE" , "MYSRC"."TTIME" FROM "I052093"."MYSRC" "MYSRC" ;'
PC_INITIATEREQ: request length: 137
PC_INITIATEREQ: Using length: 0
PC_INITIATEREQ: allocating buffer for UTF16 request
PC_INITIATEREQ: allocated buffer for UTF16 request at: 0x8131778
PC_INITIATEREQ: converting request to UTF16
PC_INITIATEREQ: leaving with return code: 0
PC_FETCHRESP: entering, expecting flavor: 8
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 8
PC_ERRORSET: Success!, Activity Count: 0
PC_ERRORSET: stmnt #: 1
PC_ERRORSET: field ct: 5
PC_ERRORSET: act type: 1
PC_ERRORSET: warningcode: 0
PC_ERRORSET: warning len: 0
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
PC_PROCESSREQ: leaving with result: 0
PC_ISREQUESTDEADLOCKED: entering
PC_ISREQUESTDEADLOCKED: CLI/DBS result 0 is not a deadlock error
PC_ISREQUESTDEADLOCKED: leaving
GETCOLUMNDATA_STMTINFO: Number of columns for stmt 1: 5
GETCOLUMNDATA_STMTINFO: allocated column handle list at: 0x812b3c8
PC_FETCHRESP: entering, expecting flavor: 169
PC_ERRORSET: entering with CLI error code: 0
PC_ERRORSET: parcel received: 169
PC_ERRORSET: error code is: 0
PC_ERRORSET: leaving with return code: 0
PC_FETCHRESP: leaving with return code: 0
GETCOLUMNDATA_STMTINFO: StatementInfo parcel body length: 650
GETCOLUMNDATA_STMTINFO: currently stmtinfo ptr at: 0x8131c72
GETCOLUMNDATA_STMTINFO: PBTILOUT: 3, PBTIID: 7, PBTILEN: 8
GETCOLUMNDATA_STMTINFO: 14 bytes processed
GETCOLUMNDATA_STMTINFO: currently stmtinfo ptr at: 0x8131c80
GETCOLUMNDATA_STMTINFO: PBTILOUT: 4, PBTIID: 7, PBTILEN: 0
GETCOLUMNDATA_STMTINFO: 20 bytes processed
GETCOLUMNDATA_STMTINFO: currently stmtinfo ptr at: 0x8131c86
GETCOLUMNDATA_STMTINFO: PBTILOUT: 1, PBTIID: 2, PBTILEN: 124
GETCOLUMNDATA_STMTINFO: allocated item list at: 135442312
GETTYPE: entering with DBS column type: 749
GETTYPE: entering with DBS format: yyyy-mm-dd
GETTYPE: entering with Precision: 0
GETTYPE: entering with Scale: 0
GETTYPE: leaving with internal column type: 15
GETTYPE: leaving with PX data type: 15
GETTYPE: leaving with Precision: 0
GETTYPE: leaving with Scale: 0
GETTYPE: leaving with PX null type: 1
GETCOLUMNDATA_STMTINFO: Name: 'tdate'
GETCOLUMNDATA_STMTINFO: Type: 749
GETCOLUMNDATA_STMTINFO: Len : 20
GETCOLUMNDATA_STMTINFO: Frmt: 'yyyy-mm-dd'
GETCOLUMNDATA_STMTINFO: Title: 'tdate'
GETCOLUMNDATA_STMTINFO: CharSet Type: 0
GETCOLUMNDATA_STMTINFO: PX Data Type: 15
GETCOLUMNDATA_STMTINFO: Precision: 0
GETCOLUMNDATA_STMTINFO: Scale: 0
GETCOLUMNDATA_STMTINFO: PX Nullable: 1
GETCOLUMNDATA_STMTINFO: Note: from PclStatementInfo got:
total digits: 0, fractional digits: 0, interval digits: 0
TPT_INFRA: TPT02205: Error: Value length conflicts with its data type: status = Length Error
TPT_INFRA: TPT02201: Error: Column 'tdate' has an invalid length or type
TPT_INFRA: TPT02345: Error: Cannot create column schema, status = Schema Error
GETCOLUMNDATA_STMTINFO: error code from PX_CreateColumnSchema: 44
PC_SETCODE: entering
PC_SETCODE: current condition code: 0
PC_SETCODE: setting condition code: 12
PC_SETCODE: leaving
myexport: TPT12111: Error 44 creating column schema
**** 21:17:19 TPT12111: Error 44 creating column schema
GETCOLUMNDATA_STMTINFO: deallocating ColHandle at: 0x812b3c8
PC_ISRETRY: entering with result, DBSError: 48, 0
PC_ISRETRY: leaving with return code: 0
GETCOLUMNINFO: leaving with return code: 48
PX_INITIATE: result from GetColumnInfo call = 48
PC_SETCODE: entering
PC_SETCODE: current condition code: 12
PC_SETCODE: leaving
PX_INITIATE: leaving with return code: 48
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: 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.06
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 =
= =
===================================================================

myexport: disconnecting sessions
**** 21:17:19 Logging off all sessions
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_LOGOFFSQL: entering
PC_LOGOFFSQL: logging off SQL Session
PC_LOGOFFSQL: leaving with result: 0
PC_DOLOGOFFSQL: logging off Main SQL Session
PC_LOGOFFSQL: entering
PC_LOGOFFSQL: logging off SQL Session
PC_LOGOFFSQL: leaving with result: 0
PC_DOLOGOFFSQL: leaving
PC_DISCCLIOPER: leaving
PX_TERMINATE: phase 2
PC_LOGJOBMETADATA: entering
PC_LOGJOBMETADATA: leaving
PC_OUTPUTCPU: entering
PC_OUTPUTCPU: start time: 'Thu Sep 23 21:17:16 2010'
PC_OUTPUTCPU: start time: 'Thu Sep 23 21:17:16 2010'
PC_OUTPUTCPU: stop time: 'Thu Sep 23 21:17:20 2010'

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.060000
PC_GETSLAVEINFO: Number of Blocks: 0
PC_GETSLAVEINFO: NoSpool Export: 0
PC_GETSLAVEINFO: retrieving CpuTime field
PC_GETSLAVEINFO: returning value: 0.060000
PC_GETSLAVEINFO: leaving
PC_GETSLAVEINFO: *************************************************
1 0.06 Seconds

**** 21:17:20 Total processor time used = '0.06 Second(s)'
. Start : Thu Sep 23 21:17:16 2010
. End : Thu Sep 23 21:17:20 2010
. Highest return code encountered = '12'.
myexport: Total processor time used = '0.06 Second(s)'
myexport: Start : Thu Sep 23 21:17:16 2010
myexport: End : Thu Sep 23 21:17:20 2010
PC_OUTPUTCPU: leaving
PC_TERMNOTIFY: entering
PC_TERMNOTIFY: leaving
PC_TERMCLIOPER: entering
**** 21:17:20 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: deallocating main logon string at: 0x81267e0
PC_FREECLIAREA: checking special logon string buffer
PC_FREECLIAREA: checking query band session info buffer
PC_FREECLIAREA: checking main utf16 logon string buffer
PC_FREECLIAREA: deallocating main utf16 logon string at: 0x8127970
PC_FREECLIAREA: checking special utf16 logon string buffer
PC_FREECLIAREA: closing utf8 converter
PC_FREECLIAREA: checking request buffer
PC_FREECLIAREA: deallocating request buffer at: 0x811d318
PC_FREECLIAREA: checking partition buffer
PC_FREECLIAREA: deallocating partition buffer at: 0x811d720
PC_FREECLIAREA: checking character set buffer
PC_FREECLIAREA: deallocating character set buffer at: 0x811d738
PC_FREECLIAREA: checking default DBCAREA buffer
PC_FREECLIAREA: deallocating default DBCAREA at: 0x811d868
PC_FREECLIAREA: checking main DBCAREA buffer
PC_FREECLIAREA: deallocating Main SQL DBCAREA at: 0x81279b0
PC_FREECLIAREA: checking Aux DBCAREA buffer
PC_FREECLIAREA: deallocating Aux SQL DBCAREA at: 0x81296f0
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 DefauleDatabase at: 0x812b0e8
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: 0x811cef0
PC_FREECLIAREA: leaving
PC_TERMCLIOPER: leaving
CLEANUP: entering
CLEANUP: deallocating event area at: 0x811cbc8
CLEANUP: deallocating private_oper_area at: 0x811cb48
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: 0x812aa38
PC_FREEITEMLIST: deallocating item list address: 0x812af88
TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11

TPT_INFRA: TPT01037: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) core dumped

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
myfile: TPT19221 Total files processed: 0.
Job step MAIN_STEP terminated (status 12)
Job TTU1310_TEST terminated (status 12)
Total available memory: 10002340
Largest allocable area: 10002340
Memory use high water mark: 45272
Free map size: 1024
Free map use high water mark: 18
Free list use high water mark: 0
Teradata Employee

Re: tbuild, failures of EXPORT operator on linux

Thank you for the detailed output.
We are looking into this.
-- SteveF
Teradata Employee

Re: tbuild, failures of EXPORT operator on linux

The Export Operator log shows an old version of the TPT Operator Support Library 13.10.00.02.

Upgrade the TPT Infrastructure package (and any other old operators) to 13.10.00.03.
-- SteveF
Enthusiast

Re: tbuild, failures of EXPORT operator on linux

Thank you for the quick reply.
I will upgrade the TPT INFRA and other operators and let you know.
Enthusiast

Re: tbuild, failures of EXPORT operator on linux

We had upgraded TPT infra and other operators.

I still failed when runing the EXPORT by UTF16 on Linux. It complaint the 'DATE' column as I implicitly converted it to CHAR.
TPT_INFRA: TPT02201: Error: Column 'tdate' has an invalid length or type
TPT_INFRA: TPT02345: Error: Cannot create column schema, status = Schema Error

The job worked successfully on windows.
tbuild -f utf16_file -e UTF16 jobname

However, if converting the to ANSI encoding as running without -e parameter. It could execute successfully.
tbuild -f ansi_file jobname

Please look into the issue and let me know you concerns.

Thanks
Teradata Employee

Re: tbuild, failures of EXPORT operator on linux

Please get in touch with Tony.Lee@Teradata.com.
He will work with you on this.
He will want you to send him the entire log (the .out file) generated for the job(s) that is(are) failing.

Thanks!
-- SteveF

Re: tbuild, failures of EXPORT operator on linux

Hi All!

I am looking for a way to export data from the result viewer on teradata to excel when I have more than 20000 records? I have a very big file I urgently need to export and when I use the export button I create the excel file but it is empty (0 kb). Any help on how to proceed would be of great help and I would really appreciate it!

Thanks!!!