All Forums Tools
M.M@TD 16 posts Joined 03/13
30 Oct 2013
TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

Hi,
I see 6 rows are exported from source database Sybase and 7 are loaded into Teradata Database.
Not able to figure out why ?
Below is the logfile details.Please help me to understand this.
Thanks !!!!!
 
 

Public log:

TPT_INFRA: TPT04101: Warning: TMSM failed to initialize
Teradata Parallel Transporter Executor Version 14.10.00.01
Teradata Parallel Transporter Coordinator Version 14.10.00.01
Teradata Parallel Transporter Executor Version 14.10.00.01
Teradata Parallel Transporter ODBC Operator Version 14.10.00.01
SYBASE_ODBC_OPERATOR: private log specified: SYBASEodbc.MyLog-1
Teradata Parallel Transporter SQL Inserter Operator Version 14.10.00.01
TDLoad_Operator: private log specified: load_log
SYBASE_ODBC_OPERATOR: connecting sessions
SYBASE_ODBC_OPERATOR: TPT17175: Warning: Message received from ODBC driver:
STATE=HY092, CODE=30101,
MSG='[Sybase][ODBC Driver]Invalid attribute or option identifier'
TDLoad_Operator: connecting sessions
TDLoad_Operator: The RDBMS retryable error code list was not found
TDLoad_Operator: The job will use its internal retryable error codes
Task(SELECT_2[0001]): checkpoint completed, status = Success
Task(APPLY_1[0001]): checkpoint completed, status = Success
SYBASE_ODBC_OPERATOR: sending SELECT request
SYBASE_ODBC_OPERATOR: data retrieval complete
SYBASE_ODBC_OPERATOR: Total Rows Exported:  6
Task(SELECT_2[0001]) ready to checkpoint

TDLoad_Operator: sending data
Task(SELECT_2[0001]): checkpoint completed, status = Success
Task(APPLY_1[0001]): checkpoint completed, status = Success
Task(SELECT_2[0001]) ready to take the EOD checkpoint

Task(SELECT_2[0001]): checkpoint completed, status = Success
Task(APPLY_1[0001]): checkpoint completed, status = Success
TDLoad_Operator: finished sending data
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 7, Total Rows Sent = 0
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 0, Total Rows Sent = 7
TDLoad_Operator: Total Rows Sent To RDBMS:      7
TDLoad_Operator: Total Rows Applied:            7
TDLoad_Operator: disconnecting sessions
SYBASE_ODBC_OPERATOR: disconnecting sessions
SYBASE_ODBC_OPERATOR: Total processor time used = '0.124801 Second(s)'
SYBASE_ODBC_OPERATOR: Start : Wed Oct 30 15:25:38 2013
SYBASE_ODBC_OPERATOR: End   : Wed Oct 30 15:25:42 2013
TDLoad_Operator: Total processor time used = '0.374402 Second(s)'
TDLoad_Operator: Start : Wed Oct 30 15:25:38 2013
TDLoad_Operator: End   : Wed Oct 30 15:25:43 2013
Job step Insert_Into_Tables terminated (status 4)
Job SYBASE-TERADATA-DIRECT-LOAD completed successfully, but with warning(s).
Job start: Wed Oct 30 15:25:35 2013
Job end:   Wed Oct 30 15:25:43 2013
Total available memory:          10000000
Largest allocable area:          10000000
Memory use high water mark:        269524
Free map size:                       1024
Free map use high water mark:          15
Free list use high water mark:          0

Private log TWB_SRCTGT:

Insert_Into_Tables   SELECT_2[0001]       SYBASE_ODBC_OPERATOR SQL                                                                                                                                                               
Insert_Into_Tables   APPLY_1[0001]        TDLoad_Operator      DBS                  192.168.72.129                                                SUPPLIER_STG.BLURBS                                                            

Private log PXCRM:

CheckPoint Resource Manager initialized.
Checking whether a valid CheckPoint exists for restart.
CheckPoint No. 1 started.
CheckPoint No. 1 finished successfully.
CheckPoint No. 2 started.
CheckPoint No. 2 finished successfully.
CheckPoint No. 3 started.
CheckPoint No. 3 finished successfully.

Private log TWB_STATUS:

Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 INITIATE-Started     15:25:38     0.0000     0.0000      65000          0                0                0     0     0 N Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 INITIATE-Started     15:25:38     0.0000     0.0000      65000          0                0                0     0     0 N Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 INITIATE-Ended       15:25:38     0.0000     0.0780      65000          0                0                0     0     0 N Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 INITIATE-Ended       15:25:38     0.0000     0.3276      65000          0                0                0     0     0 N Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 EXECUTE-Started      15:25:38     0.0000     0.0000      65000          0                0                0     0     0 N Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 EXECUTE-Started      15:25:38     0.0000     0.0000      65000          0                0                0     0     0 N Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 CHECKPOINT-Started   15:25:38     0.0000     0.0000      65000          0                0                0     0     0 N Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 CHECKPOINT-Started   15:25:38     0.0000     0.0000      65000          0                0                0     0     0 N Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 CHECKPOINT-Ended     15:25:39     1.0000     0.0000      65000          0                0                0     0     0 N Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 CHECKPOINT-Ended     15:25:39     1.0000     0.0156      65000          0                0                0     0     0 N Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 CHECKPOINT-Started   15:25:39     1.0000     0.0156      65000          1                0                7     0     0 Y Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 CHECKPOINT-Started   15:25:40     2.0000     0.0156      65000          1                7                0     0     0 N Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 CHECKPOINT-Ended     15:25:40     2.0000     0.0312      65000          1                0                7     0     0 Y Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 CHECKPOINT-Ended     15:25:41     3.0000     0.0312      65000          1                7                0     0     0 N Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 CHECKPOINT-Started   15:25:41     3.0000     0.0312      65000          1                7                0     0     0 Y Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 CHECKPOINT-Started   15:25:41     3.0000     0.0312      65000          1                0                7     0     0 Y Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 CHECKPOINT-Ended     15:25:42     4.0000     0.0312      65000          1                0                7     0     0 Y Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 CHECKPOINT-Ended     15:25:42     4.0000     0.0312      65000          1                7                0     0     0 Y Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 EXECUTE-Ended        15:25:42     4.0000     0.0312      65000          1                0                7     0     0 Y Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 EXECUTE-Ended        15:25:42     4.0000     0.0312      65000          1                7                0     0     0 Y Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 TERMINATE-Started    15:25:42     0.0000     0.0000      65000          0                0                0     0     0 Y Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 TERMINATE-Started    15:25:42     0.0000     0.0000      65000          0                0                0     0     0 Y Y
Insert_Into_Tables   SELECT_2[0001]       Success              SYBASE_ODBC_OPERATOR    1    1 TERMINATE-Ended      15:25:42     0.0000     0.0312      65000          0                0                0     0     0 Y Y
Insert_Into_Tables   APPLY_1[0001]        Success              TDLoad_Operator         1    1 TERMINATE-Ended      15:25:43     1.0000     0.0000      65000          0                0                0     0     0 Y Y

Private log SYBASEodbc.MyLog-1:

PC_GETOPERATTRS: *************************************************
PC_GETOPERATTRS: entering handle:   0x6e8218
PC_GETOPERATTRS: MyOperatorName:    'SYBASE_ODBC_OPERATOR'
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:       0x106
PC_GETOPERATTRS: PublicLog Handle:  0x6e82dc
PC_GETOPERATTRS: PrivateLog Handle: 0x6e82ec
PC_GETOPERATTRS: Private Log name:  'SYBASEodbc.MyLog-1'
PC_GETOPERATTRS: bytes for glblmsg: 2097152
PC_GETOPERATTRS: size of oper_desc: 352
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: 'T'
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: not set by user
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'
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
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                  =
     =                                                                 =
     =              ODBC OPERATOR     VERSION 14.10.00.01              =
     =                                                                 =
     =          OPERATOR SUPPORT LIBRARY VERSION 14.10.00.01           =
     =                                                                 =
     = COPYRIGHT 2001-2013, TERADATA CORPORATION. ALL RIGHTS RESERVED. =
     =                                                                 =
     ====================================================== =============

**** 15:25:38 Processing starting at: Wed Oct 30 15:25:38 2013
PC_SHOWVERSION: entering
PC_SHOWVERSION: operator name: ODBC
 
     ====================================================== =============
     =                                                                 =
     =                      Module Identification                      =
     =                                                                 =
     ====================================================== =============

PC_SHOWVERSION: node name:   'WUSMM255065-H2T'
     ODBC Operator for Windows on WUSMM255065-H2T
PC_SHOWVERSION: module id: 'ODBCMain', module vers: '14.10.00.05'
     ODBCMain   : 14.10.00.05
PC_SHOWVERSION: module id: 'ODBCSQL', module vers: '14.10.00.05'
     ODBCSQL    : 14.10.00.05
PC_SHOWVERSION: module id: 'ODBCUtil', module vers: '14.10.00.02'
     ODBCUtil   : 14.10.00.02
PC_SHOWVERSION: module id: 'PcomCLI', module vers: '14.10.00.31'
     PcomCLI    : 14.10.00.31
PC_SHOWVERSION: module id: 'PcomMBCS', module vers: '14.10.00.02'
     PcomMBCS   : 14.10.00.02
PC_SHOWVERSION: module id: 'PcomMsgs', module vers: '14.10.00.02'
     PcomMsgs   : 14.10.00.02
PC_SHOWVERSION: module id: 'PcomNtfy', module vers: '14.10.00.05'
     PcomNtfy   : 14.10.00.05
PC_SHOWVERSION: module id: 'PcomPx', module vers: '14.10.00.10'
     PcomPx     : 14.10.00.10
PC_SHOWVERSION: module id: 'PcomUtil', module vers: '14.10.00.09'
     PcomUtil   : 14.10.00.09
     PXICU      : 14.10.00.01
     TDICU      : 14.10.00.00
PC_SHOWVERSION: leaving
PC_GETSCHEMAHANDLE: entering
PC_GETSCHEMAHANDLE: schema handle: 0x6e103c
PC_GETSCHEMAHANDLE: leaving
PC_GETCOLUMNSCHEMA: entering
PC_GETCOLUMNSCHEMA: address of list:     0x6e6074
PC_GETCOLUMNSCHEMA: number of columns:   1
PC_GETCOLUMNSCHEMA: number of indicator bytes: 1
PC_GETCOLUMNSCHEMA: received column handle: 0x6e6048
PC_GETCOLUMNSCHEMA: allocated item list at: 0x6e11e0
PC_GETCOLUMNSCHEMA: Name, Type, Size: 'au_id', 7, 36
PC_GETCOLUMNSCHEMA: Prec, Scale: 0, 0
PC_GETCOLUMNSCHEMA: attempting to malloc 6 bytes
PC_VALIDATECOLTYPE: entering with column type: 7
PC_GETCOLUMNSCHEMA:
PC_GETCOLUMNSCHEMA: Final Column List
PC_GETCOLUMNSCHEMA: -----------------
PC_GETCOLUMNSCHEMA: Address: 0x6e11e0, next: 0x0
PC_GETCOLUMNSCHEMA:
PC_GETCOLUMNSCHEMA: itemhdr address: 0x6e11e0

PC_OUTCOLLIST: ========================================
PC_OUTCOLLIST:   1. Field Name: au_id
PC_OUTCOLLIST:      Type:  VARCHAR
PC_OUTCOLLIST:      Size:  36
PC_OUTCOLLIST:      Prec:  0
PC_OUTCOLLIST:      Scale: 0
PC_OUTCOLLIST:
PC_OUTCOLLIST: There are 1 fields defined
PC_OUTCOLLIST: ========================================

PC_GETCOLUMNSCHEMA: leaving
PC_INITOPERATOR: latency flag is: 0
PC_INITOPERATOR: leaving
PX_INITIATE: phase 1
GETMYATTRIBUTES: entering
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'DSNName'
PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSExternalName'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 13
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: Dsn Id: 'SYBASE_ASE_DB'
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'UserName'
PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSUserName'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 2
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: logon user id: 'sa'
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'UserPassword'
PC_GETATTRIBUTE: alt attr:  'SYSTEM_DBMSPassword'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 8
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: logon password: 'Miami123'
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SelectStmt'
PC_GETATTRIBUTE: mandatory: 1
PC_GETATTRIBUTE: attribute length: 37
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: SELECT request: ' select au_id from pubs2.dbo.blurbs ;'
GETMYATTRIBUTES: **********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'ConnectString'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'ConnectString' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: **********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'TruncateData'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 1
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: TruncateData: 1
GETMYATTRIBUTES: **********************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'RowSetSize'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'RowSetSize' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'DataBlockSize'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'DataBlockSize' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: *************************************************
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'FetchDataBlock'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute: 'FetchDataBlock' not found
PC_GETATTRIBUTE: optional attribute not found
PC_GETATTRIBUTE: leaving
GETMYATTRIBUTES: leaving
OPENCONVERTER: entering
OPENCONVERTER: UTF Converter Initialized; leaving
PC_OUTPUTATTRS: entering
 
     ====================================================== =============
     =                                                                 =
     =                      Attribute Definitions                      =
     =                                                                 =
     ====================================================== =============

**** 15:25:38 Options in effect for this job:
              OperatorType:  Producer
              Instances:     1
              Character set: Not specified; will use default
              Checkpoint:    No checkpoint in effect
              Trace Option:  'PXOPERROW'
              Trace Output:  Enabled
PC_OUTPUTATTRS: leaving
              DataBlockSize: 64K bytes
PX_INITIATE: phase 2
 
     ====================================================== =============
     =                                                                 =
     =                     SQL Session Connection                      =
     =                                                                 =
     ====================================================== =============

**** 15:25:38 Connecting to RDBMS:    'SYBASE_ASE_DB'
**** 15:25:38 Connecting with UserId: 'sa'
PC_SETCODE: entering
PC_SETCODE: current condition code: 0
PC_SETCODE: setting condition code: 4
PC_SETCODE: leaving
**** 15:25:38 TPT17175: Warning: Message received from ODBC driver:
STATE=HY092, CODE=30101,
MSG='[Sybase][ODBC Driver]Invalid attribute or option identifier'
 
     ====================================================== =============
     =                                                                 =
     =                     ODBC Driver Information                     =
     =                                                                 =
     ====================================================== =============

     ODBC version        = '03.80.0000'
     DBMS name           = 'SQL Server'
     DBMS version        = '15.7.0'
     Driver name         = 'Adaptive Server Enterprise'
     Driver version      = '15.7.0.401'
     Driver ODBC version = '03.51'
PX_INITIATE: phase 3
 
     ====================================================== =============
     =                                                                 =
     =               Source Table Column/Field Defintion               =
     =                                                                 =
     ====================================================== =============

ALLOCATEITEMEX: entering
ALLOCATEITEMEX: address of item list: 0x780218
ALLOCATEITEM: leaving
ALLOCATEITEMEX: entering
ALLOCATEITEMEX: address of item list: 0x780230
ALLOCATEITEM: leaving
PC_ALLOCATEITEM: entering
PC_ALLOCATEITEM: address of item list: 0x703968
PC_ALLOCATEITEM: leaving
SHOWLAYOUT: entering
     Column Name                    Offset Length Type     
     ============================== ====== ====== ========================
     au_id                               0     11 varchar
     ============================== ====== ====== ========================
     EXPECTED RECORD LENGTH: 11
SHOWLAYOUT: leaving
PC_SHOWLAYOUT: entering
 
     ====================================================== =============
     =                                                                 =
     =                     Column/Field Definition                     =
     =                                                                 =
     ====================================================== =============

     Column Name                    Offset Length Type     
     ============================== ====== ====== ========================
     au_id                               0     36 VARCHAR
     ============================== ====== ====== ========================
     INDICATOR BYTES NEEDED: 1
     EXPECTED RECORD LENGTH: 39
PC_SHOWLAYOUT: leaving
PC_GETROWSIZE: entering
PC_GETROWSIZE: rowsize: 39
PC_GETROWSIZE: leaving
ALLOCATESHAREDMEM: entering
ALLOCATESHAREDMEM: shmtok_ctr: 1
ALLOCATESHAREDMEM: creating global variable Data_ShmTokens_Tbl
ALLOCATESHAREDMEM: creating global variable FetchInfo_ShmKey
ALLOCATESHAREDMEM: array shm_toks starts at 04dccf8
ALLOCATESHAREDMEM: obtaining shm token for reserved area
ALLOCATESHAREDMEM: shm_tok: 0x2633c20
ALLOCATESHAREDMEM: updating global variable FetchInfo_ShmKey
ALLOCATESHAREDMEM: attaching shm_tok 0x2633c20
ALLOCATESHAREDMEM: my_area->shm_ptr: 0x25f3c20
ALLOCATESHAREDMEM: obtaining shm token for requested 10922 bytes
ALLOCATESHAREDMEM: shm_tok: 0x2633cf0
ALLOCATESHAREDMEM: updating global variable Data_ShmTokens_Tbl
ALLOCATESHAREDMEM: attaching shm_tok 0x2633cf0
ALLOCATESHAREDMEM: requested shared memory statrs at: 0x25f3cf0
ALLOCATESHAREDMEM: entering
ALLOCATESHAREDMEM: shmtok_ctr: 2
ALLOCATESHAREDMEM: obtaining shm token for requested 10922 bytes
ALLOCATESHAREDMEM: shm_tok: 0x26367a4
ALLOCATESHAREDMEM: updating global variable Data_ShmTokens_Tbl
ALLOCATESHAREDMEM: attaching shm_tok 0x26367a4
ALLOCATESHAREDMEM: requested shared memory statrs at: 0x25f67a4
ALLOCATESHAREDMEM: entering
ALLOCATESHAREDMEM: shmtok_ctr: 3
ALLOCATESHAREDMEM: obtaining shm token for requested 21844 bytes
ALLOCATESHAREDMEM: shm_tok: 0x2639258
ALLOCATESHAREDMEM: updating global variable Data_ShmTokens_Tbl
ALLOCATESHAREDMEM: attaching shm_tok 0x2639258
ALLOCATESHAREDMEM: requested shared memory statrs at: 0x25f9258
ALLOCATESHAREDMEM: entering
ALLOCATESHAREDMEM: shmtok_ctr: 4
ALLOCATESHAREDMEM: obtaining shm token for requested 21844 bytes
ALLOCATESHAREDMEM: shm_tok: 0x263e7b4
ALLOCATESHAREDMEM: updating global variable Data_ShmTokens_Tbl
ALLOCATESHAREDMEM: attaching shm_tok 0x263e7b4
ALLOCATESHAREDMEM: requested shared memory statrs at: 0x25fe7b4
ALLOCATESHAREDMEM: entering
ALLOCATESHAREDMEM: shmtok_ctr: 5
ALLOCATESHAREDMEM: obtaining shm token for requested 65532 bytes
ALLOCATESHAREDMEM: shm_tok: 0x2643d10
ALLOCATESHAREDMEM: updating global variable Data_ShmTokens_Tbl
ALLOCATESHAREDMEM: attaching shm_tok 0x2643d10
ALLOCATESHAREDMEM: requested shared memory statrs at: 0x2603d10
ALLOCATESHAREDMEM: entering
ALLOCATESHAREDMEM: shmtok_ctr: 6
ALLOCATESHAREDMEM: obtaining shm token for requested 65532 bytes
ALLOCATESHAREDMEM: shm_tok: 0x2653d14
ALLOCATESHAREDMEM: updating global variable Data_ShmTokens_Tbl
ALLOCATESHAREDMEM: attaching shm_tok 0x2653d14
ALLOCATESHAREDMEM: requested shared memory statrs at: 0x2613d14
CREATESELSCHMVARS: entering
CREATESELSCHMVARS: copying info for column #1
CREATESELSCHMVARS: copying info ext. for column #1
CREATESELSCHMVARS: copying name for column #1
CREATESELSCHMVARS: leaving with result: 0
PX_INITIATE: phase 4
PX_CHECKPOINT: entering.
PX_CHECKPOINT: Updated INIT checkpoint.
PX_CHECKPOINT: returning PX_EndMethod.
PX_EXECUTE: phase 1
PC_GETATTRIBUTE: entering
PC_GETATTRIBUTE: attribute: 'SYSTEM_BufferMode'
PC_GETATTRIBUTE: mandatory: 0
PC_GETATTRIBUTE: attribute length: 1
PC_GETATTRIBUTE: successfully retrieved attribute
PC_GETATTRIBUTE: leaving
GETBUFFERLAYOUT: BufferMode: 'N'
PC_GETCPUTIME: entering
PC_GETCPUTIME: leaving
 
     ====================================================== =============
     =                                                                 =
     =                         Select Request                          =
     =                                                                 =
     ====================================================== =============

**** 15:25:39 This job is submitting the following request:
 
      select au_id from pubs2.dbo.blurbs ;
 
     RowSet size per fetched data block:  5461
 
PX_EXECUTE: phase: 2, working buf_idx: 0
FETCHDATA: entering
FETCHDATA: fetched multiple rows: 6
FETCHDATA: RowStatus[0]=0
FETCHDATA: RowStatus[1]=0
FETCHDATA: RowStatus[2]=0
FETCHDATA: RowStatus[3]=0
FETCHDATA: RowStatus[4]=0
FETCHDATA: RowStatus[5]=0
FETCHDATA: leaving with result: 0
PX_EXECUTE: result of FetchData: 0, next buf_idx: 1
PX_EXECUTE: phase: 3, working buf_idx: 1
PX_EXECUTE: TotaleRows: 6, EndOfData: 0
PX_EXECUTE: Instance #1 starts at row #0
SENDDATA: entering
FETCHROW: entering
FETCHROW: processing row #: 1
FETCHROW: number of indicator bytes for this row: 1
FETCHROW: column 1, size(max): 11, ret len: 11, value: '486-29-1786'

The current Item is: au_id
FETCHROW: dump buffer outrec
PC_HEXDUMP: entering
PC_HEXDUMP: max bytes, reclen: 14, 14
  Hexadecimal formatted display from address 0073F4A8 for 14 bytes.

   0000  00 0B 00 34.38 36 2D 32.39 2D 31 37.38 36        *...486-29-1786  *
PC_HEXDUMP: leaving
FETCHROW: leaving
SENDDATA: sending row with size: 14
SENDDATA: leaving
PX_EXECUTE: SendData returned with result: 0
PX_EXECUTE: phase: 3, working buf_idx: 0
PX_EXECUTE: TotaleRows: 6, EndOfData: 0
PX_EXECUTE: Instance #1 starts at row #1
SENDDATA: entering
FETCHROW: entering
FETCHROW: processing row #: 2
FETCHROW: number of indicator bytes for this row: 1
FETCHROW: column 1, size(max): 11, ret len: 11, value: '648-92-1872'

The current Item is: au_id
FETCHROW: dump buffer outrec
PC_HEXDUMP: entering
PC_HEXDUMP: max bytes, reclen: 14, 14
  Hexadecimal formatted display from address 0073F4A8 for 14 bytes.

   0000  00 0B 00 36.34 38 2D 39.32 2D 31 38.37 32        *...648-92-1872  *
PC_HEXDUMP: leaving
FETCHROW: leaving
SENDDATA: sending row with size: 14
SENDDATA: leaving
PX_EXECUTE: SendData returned with result: 0
PX_EXECUTE: phase: 3, working buf_idx: 0
PX_EXECUTE: TotaleRows: 6, EndOfData: 0
PX_EXECUTE: Instance #1 starts at row #2
SENDDATA: entering
FETCHROW: entering
FETCHROW: processing row #: 3
FETCHROW: number of indicator bytes for this row: 1
FETCHROW: column 1, size(max): 11, ret len: 11, value: '998-72-3567'

The current Item is: au_id
FETCHROW: dump buffer outrec
PC_HEXDUMP: entering
PC_HEXDUMP: max bytes, reclen: 14, 14
  Hexadecimal formatted display from address 0073F4A8 for 14 bytes.

   0000  00 0B 00 39.39 38 2D 37.32 2D 33 35.36 37        *...998-72-3567  *
PC_HEXDUMP: leaving
FETCHROW: leaving
SENDDATA: sending row with size: 14
SENDDATA: leaving
PX_EXECUTE: SendData returned with result: 0
PX_EXECUTE: phase: 3, working buf_idx: 0
PX_EXECUTE: TotaleRows: 6, EndOfData: 0
PX_EXECUTE: Instance #1 starts at row #3
SENDDATA: entering
FETCHROW: entering
FETCHROW: processing row #: 4
FETCHROW: number of indicator bytes for this row: 1
FETCHROW: column 1, size(max): 11, ret len: 11, value: '899-46-2035'

The current Item is: au_id
FETCHROW: dump buffer outrec
PC_HEXDUMP: entering
PC_HEXDUMP: max bytes, reclen: 14, 14
  Hexadecimal formatted display from address 0073F4A8 for 14 bytes.

   0000  00 0B 00 38.39 39 2D 34.36 2D 32 30.33 35        *...899-46-2035  *
PC_HEXDUMP: leaving
FETCHROW: leaving
SENDDATA: sending row with size: 14
SENDDATA: leaving
PX_EXECUTE: SendData returned with result: 0
PX_EXECUTE: phase: 3, working buf_idx: 0
PX_EXECUTE: TotaleRows: 6, EndOfData: 0
PX_EXECUTE: Instance #1 starts at row #4
SENDDATA: entering
FETCHROW: entering
FETCHROW: processing row #: 5
FETCHROW: number of indicator bytes for this row: 1
FETCHROW: column 1, size(max): 11, ret len: 11, value: '672-71-3249'

The current Item is: au_id
FETCHROW: dump buffer outrec
PC_HEXDUMP: entering
PC_HEXDUMP: max bytes, reclen: 14, 14
  Hexadecimal formatted display from address 0073F4A8 for 14 bytes.

   0000  00 0B 00 36.37 32 2D 37.31 2D 33 32.34 39        *...672-71-3249  *
PC_HEXDUMP: leaving
FETCHROW: leaving
SENDDATA: sending row with size: 14
SENDDATA: leaving
PX_EXECUTE: SendData returned with result: 0
PX_EXECUTE: phase: 3, working buf_idx: 0
PX_EXECUTE: TotaleRows: 6, EndOfData: 0
PX_EXECUTE: Instance #1 starts at row #5
SENDDATA: entering
FETCHROW: entering
FETCHROW: processing row #: 6
FETCHROW: number of indicator bytes for this row: 1
FETCHROW: column 1, size(max): 11, ret len: 11, value: '409-56-7008'

The current Item is: au_id
FETCHROW: dump buffer outrec
PC_HEXDUMP: entering
PC_HEXDUMP: max bytes, reclen: 14, 14
  Hexadecimal formatted display from address 0073F4A8 for 14 bytes.

   0000  00 0B 00 34.30 39 2D 35.36 2D 37 30.30 38        *...409-56-7008  *
PC_HEXDUMP: leaving
FETCHROW: leaving
SENDDATA: sending row with size: 14
SENDDATA: leaving
PX_EXECUTE: SendData returned with result: 0
PX_EXECUTE: phase: 3, working buf_idx: 0
PX_EXECUTE: TotaleRows: 6, EndOfData: 0
PX_EXECUTE: Instance #1 starts at row #6
SENDDATA: entering
FETCHROW: entering
FETCHROW: leaving, end of data block
PX_EXECUTE: SendData returned with result: 99
PX_EXECUTE: phase: 3, working buf_idx: 0
PX_EXECUTE: next buf_idx: 1
PX_EXECUTE: phase: 4, working buf_idx: 1
PX_EXECUTE: EndOfData: 0
PX_EXECUTE: phase: 2, working buf_idx: 0
FETCHDATA: entering
     Total number of fetches: 2
PX_EXECUTE: result of FetchData: 12, next buf_idx: 0
PX_EXECUTE: phase: 3, working buf_idx: 0
PX_EXECUTE: TotaleRows: 0, EndOfData: 1
PX_EXECUTE: phase: 4, working buf_idx: 0
PX_EXECUTE: EndOfData: 1
PX_EXECUTE: phase 5
PC_GETCPUTIME: entering
PC_GETCPUTIME: leaving
PC_UPDATESLAVEINFO: ************************************************
PC_UPDATESLAVEINFO: entering
PC_UPDATESLAVEINFO: Instance: 1 after read
PC_UPDATESLAVEINFO: Number of Bytes:     104
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: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Number Of Stmts:     0
PC_UPDATESLAVEINFO: Use MLX:             0
PC_UPDATESLAVEINFO: Rows Exported:       0
PC_UPDATESLAVEINFO: Rows Sent To DBS:    0
PC_UPDATESLAVEINFO: Number of Blocks:    0
PC_UPDATESLAVEINFO: NoSpool Export:      0
PC_UPDATESLAVEINFO: Bytes Sent To DBS:   0
PC_UPDATESLAVEINFO: Bytes Exported:      0
PC_UPDATESLAVEINFO: updating Export Phase CpuTime field
PC_UPDATESLAVEINFO: Instance: 1 before write
PC_UPDATESLAVEINFO: Number of Bytes:     104
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: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0.0156001
PC_UPDATESLAVEINFO: Number Of Stmts:     0
PC_UPDATESLAVEINFO: Use MLX:             0
PC_UPDATESLAVEINFO: Rows Exported:       0
PC_UPDATESLAVEINFO: Rows Sent To DBS     0
PC_UPDATESLAVEINFO: Number of Blocks     0
PC_UPDATESLAVEINFO: NoSpool Export:      0
PC_UPDATESLAVEINFO: Bytes Sent To DBS    0
PC_UPDATESLAVEINFO: Bytes Exported:      0
PC_UPDATESLAVEINFO: leaving with result: 0
PC_UPDATESLAVEINFO: ************************************************
**** 15:25:39 Finished receiving rows from the data source
PC_UPDATESLAVEINFO: ************************************************
PC_UPDATESLAVEINFO: entering
PC_UPDATESLAVEINFO: Instance: 1 after read
PC_UPDATESLAVEINFO: Number of Bytes:     104
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: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0.0156001
PC_UPDATESLAVEINFO: Number Of Stmts:     0
PC_UPDATESLAVEINFO: Use MLX:             0
PC_UPDATESLAVEINFO: Rows Exported:       0
PC_UPDATESLAVEINFO: Rows Sent To DBS:    0
PC_UPDATESLAVEINFO: Number of Blocks:    0
PC_UPDATESLAVEINFO: NoSpool Export:      0
PC_UPDATESLAVEINFO: Bytes Sent To DBS:   0
PC_UPDATESLAVEINFO: Bytes Exported:      0
PC_UPDATESLAVEINFO: updating RowsExported field
PC_UPDATESLAVEINFO: Instance: 1 before write
PC_UPDATESLAVEINFO: Number of Bytes:     104
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: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0.0156001
PC_UPDATESLAVEINFO: Number Of Stmts:     0
PC_UPDATESLAVEINFO: Use MLX:             0
PC_UPDATESLAVEINFO: Rows Exported:       6
PC_UPDATESLAVEINFO: Rows Sent To DBS     0
PC_UPDATESLAVEINFO: Number of Blocks     0
PC_UPDATESLAVEINFO: NoSpool Export:      0
PC_UPDATESLAVEINFO: Bytes Sent To DBS    0
PC_UPDATESLAVEINFO: Bytes Exported:      0
PC_UPDATESLAVEINFO: leaving with result: 0
PC_UPDATESLAVEINFO: ************************************************
PC_UPDATESLAVEINFO: ************************************************
PC_UPDATESLAVEINFO: entering
PC_UPDATESLAVEINFO: Instance: 1 after read
PC_UPDATESLAVEINFO: Number of Bytes:     104
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: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0.0156001
PC_UPDATESLAVEINFO: Number Of Stmts:     0
PC_UPDATESLAVEINFO: Use MLX:             0
PC_UPDATESLAVEINFO: Rows Exported:       6
PC_UPDATESLAVEINFO: Rows Sent To DBS:    0
PC_UPDATESLAVEINFO: Number of Blocks:    0
PC_UPDATESLAVEINFO: NoSpool Export:      0
PC_UPDATESLAVEINFO: Bytes Sent To DBS:   0
PC_UPDATESLAVEINFO: Bytes Exported:      0
PC_UPDATESLAVEINFO: updating BytesExpFromDBS field
PC_UPDATESLAVEINFO: Instance: 1 before write
PC_UPDATESLAVEINFO: Number of Bytes:     104
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: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0.0156001
PC_UPDATESLAVEINFO: Number Of Stmts:     0
PC_UPDATESLAVEINFO: Use MLX:             0
PC_UPDATESLAVEINFO: Rows Exported:       6
PC_UPDATESLAVEINFO: Rows Sent To DBS     0
PC_UPDATESLAVEINFO: Number of Blocks     0
PC_UPDATESLAVEINFO: NoSpool Export:      0
PC_UPDATESLAVEINFO: Bytes Sent To DBS    0
PC_UPDATESLAVEINFO: Bytes Exported:      84
PC_UPDATESLAVEINFO: leaving with result: 0
PC_UPDATESLAVEINFO: ************************************************
PX_EXECUTE: phase 6
 
     ====================================================== =============
     =                                                                 =
     =                       Row Export Complete                       =
     =                                                                 =
     ====================================================== =============

 
                        Instance  Rows Exported
                        ========  =======================
PC_GETSLAVEINFO: *************************************************
PC_GETSLAVEINFO: entering
PC_GETSLAVEINFO: Instance: 1
PC_GETSLAVEINFO: field:    9
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:       6
PC_GETSLAVEINFO: Rows Sent To DBS:    0
PC_GETSLAVEINFO: Cpu Time:            0.000000
PC_GETSLAVEINFO: Load Phase Cpu Time: 0.000000
PC_GETSLAVEINFO: Export Phase Cpu Time: 0.015600
PC_GETSLAVEINFO: Number of Blocks:    0
PC_GETSLAVEINFO: NoSpool Export:      0
PC_GETSLAVEINFO: UseMLX:              0
PC_GETSLAVEINFO: Bytes Sent To DBS:   0
PC_GETSLAVEINFO: Bytes Exported:      84
PC_GETSLAVEINFO: retrieving RowsExported field
PC_GETSLAVEINFO: returning value: 6
PC_GETSLAVEINFO: leaving
PC_GETSLAVEINFO: *************************************************
                            1                         6
                        ========  =======================
                          Total                       6
OUTPUTSTATISTICS: entering
PC_GETSLAVEINFO: *************************************************
PC_GETSLAVEINFO: entering
PC_GETSLAVEINFO: Instance: 1
PC_GETSLAVEINFO: field:    16
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:       6
PC_GETSLAVEINFO: Rows Sent To DBS:    0
PC_GETSLAVEINFO: Cpu Time:            0.000000
PC_GETSLAVEINFO: Load Phase Cpu Time: 0.000000
PC_GETSLAVEINFO: Export Phase Cpu Time: 0.015600
PC_GETSLAVEINFO: Number of Blocks:    0
PC_GETSLAVEINFO: NoSpool Export:      0
PC_GETSLAVEINFO: UseMLX:              0
PC_GETSLAVEINFO: Bytes Sent To DBS:   0
PC_GETSLAVEINFO: Bytes Exported:      84
PC_GETSLAVEINFO: retrieving Export Phase CpuTime field
PC_GETSLAVEINFO: returning value: 0.015600
PC_GETSLAVEINFO: leaving
PC_GETSLAVEINFO: *************************************************
PC_GETSLAVEINFO: *************************************************
PC_GETSLAVEINFO: entering
PC_GETSLAVEINFO: Instance: 1
PC_GETSLAVEINFO: field:    14
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:       6
PC_GETSLAVEINFO: Rows Sent To DBS:    0
PC_GETSLAVEINFO: Cpu Time:            0.000000
PC_GETSLAVEINFO: Load Phase Cpu Time: 0.000000
PC_GETSLAVEINFO: Export Phase Cpu Time: 0.015600
PC_GETSLAVEINFO: Number of Blocks:    0
PC_GETSLAVEINFO: NoSpool Export:      0
PC_GETSLAVEINFO: UseMLX:              0
PC_GETSLAVEINFO: Bytes Sent To DBS:   0
PC_GETSLAVEINFO: Bytes Exported:      84
PC_GETSLAVEINFO: retrieving BytesExpFromDBS field
PC_GETSLAVEINFO: returning value: 84
PC_GETSLAVEINFO: leaving
PC_GETSLAVEINFO: *************************************************
 
**** 15:25:39 Export Phase statistics:
Elapsed time: 00:00:00:00 (hh:mm:ss)
CPU time:     0.0156001 Second(s)
MB/sec:       could not be determined
MB/cpusec:    0.005
OUTPUTSTATISTICS: leaving
PX_CHECKPOINT: entering.
PX_CHECKPOINT: Updated EOD checkpoint.
PX_CHECKPOINT: returning PX_EndMethod.
PX_CHECKPOINT: entering.
PX_CHECKPOINT: Updated EOD checkpoint.
PX_CHECKPOINT: returning PX_EndMethod.
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_REPORTERROR: ll_arg1: 0
PC_REPORTERROR: ll_arg2: 0
PC_REPORTERROR: ll_arg3: 0
PC_REPORTERROR: ll_arg4: 0
PC_REPORTERROR: ll_arg5: 0
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:     104
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: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0.0156001
PC_UPDATESLAVEINFO: Number Of Stmts:     0
PC_UPDATESLAVEINFO: Use MLX:             0
PC_UPDATESLAVEINFO: Rows Exported:       6
PC_UPDATESLAVEINFO: Rows Sent To DBS:    0
PC_UPDATESLAVEINFO: Number of Blocks:    0
PC_UPDATESLAVEINFO: NoSpool Export:      0
PC_UPDATESLAVEINFO: Bytes Sent To DBS:   0
PC_UPDATESLAVEINFO: Bytes Exported:      84
PC_UPDATESLAVEINFO: updating CpuTime field
PC_UPDATESLAVEINFO: Instance: 1 before write
PC_UPDATESLAVEINFO: Number of Bytes:     104
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.124801
PC_UPDATESLAVEINFO: Load Phase Cpu Time: 0
PC_UPDATESLAVEINFO: Export Phase Cpu Time: 0.0156001
PC_UPDATESLAVEINFO: Number Of Stmts:     0
PC_UPDATESLAVEINFO: Use MLX:             0
PC_UPDATESLAVEINFO: Rows Exported:       6
PC_UPDATESLAVEINFO: Rows Sent To DBS     0
PC_UPDATESLAVEINFO: Number of Blocks     0
PC_UPDATESLAVEINFO: NoSpool Export:      0
PC_UPDATESLAVEINFO: Bytes Sent To DBS    0
PC_UPDATESLAVEINFO: Bytes Exported:      84
PC_UPDATESLAVEINFO: leaving with result: 0
PC_UPDATESLAVEINFO: ************************************************
PC_CHECKOPERINIT: leaving
PX_TERMINATE: phase 1
 
     ====================================================== =============
     =                                                                 =
     =                        Logoff/Disconnect                        =
     =                                                                 =
     ====================================================== =============

**** 15:25:42 Logging off all sessions
PX_TERMINATE: phase 2
PC_OUTPUTCPU: entering
PC_OUTPUTCPU: start time: 'Wed Oct 30 15:25:38 2013'
PC_OUTPUTCPU: start time: 'Wed Oct 30 15:25:38 2013'
PC_OUTPUTCPU: stop  time: 'Wed Oct 30 15:25:42 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:       6
PC_GETSLAVEINFO: Rows Sent To DBS:    0
PC_GETSLAVEINFO: Cpu Time:            0.124801
PC_GETSLAVEINFO: Load Phase Cpu Time: 0.000000
PC_GETSLAVEINFO: Export Phase Cpu Time: 0.015600
PC_GETSLAVEINFO: Number of Blocks:    0
PC_GETSLAVEINFO: NoSpool Export:      0
PC_GETSLAVEINFO: UseMLX:              0
PC_GETSLAVEINFO: Bytes Sent To DBS:   0
PC_GETSLAVEINFO: Bytes Exported:      84
PC_GETSLAVEINFO: retrieving CpuTime field
PC_GETSLAVEINFO: returning value: 0.124801
PC_GETSLAVEINFO: leaving
PC_GETSLAVEINFO: *************************************************
                   1        0.12 Seconds
 
**** 15:25:42 Total processor time used = '0.124801 Second(s)'
.        Start : Wed Oct 30 15:25:38 2013
.        End   : Wed Oct 30 15:25:42 2013
.        Highest return code encountered = '4'.
PC_OUTPUTCPU: leaving
**** 15:25:42 This job terminated
CLEANUP: entering
CLEANUP: closing UTF converter.
CLEANUP: deallocating Dsn string at: 0x4db6c0
CLEANUP: deallocating UserName string at: 0x4d1ae0
CLEANUP: deallocating UserPassword string at: 0x4db708
CLEANUP: deallocating SelectStmtPtr string at: 0x4df168
FREEFIELDLIST: entering
FREEFIELDLIST: deallocating field list
FREEFIELDLIST: deallocating datatype address: 0x77f840
FREEFIELDLIST: deallocating field list address: 0x774358
FREEFIELDLIST: deallocating datatype address: 0x703330
FREEFIELDLIST: deallocating field list address: 0x774378
FREEFIELDLIST: deallocating datatype address: 0x77f868
FREEFIELDLIST: deallocating field list address: 0x7803b8
FREEFIELDLIST: deallocating datatype address: 0x780320
FREEFIELDLIST: deallocating field list address: 0x7803d8
FREEFIELDLIST: deallocating datatype address: 0x77f890
FREEFIELDLIST: deallocating field list address: 0x7803f8
FREEFIELDLIST: deallocating datatype address: 0x77f8b8
FREEFIELDLIST: deallocating field list address: 0x780418
FREEFIELDLIST: deallocating datatype address: 0x703920
FREEFIELDLIST: deallocating field list address: 0x780438
FREEFIELDLIST: deallocating datatype address: 0x780478
FREEFIELDLIST: deallocating field list address: 0x780458
FREEFIELDLIST: deallocating datatype address: 0x70e658
FREEFIELDLIST: deallocating field list address: 0x780498
FREEFIELDLIST: deallocating datatype address: 0x70e688
FREEFIELDLIST: deallocating field list address: 0x7804b8
FREEFIELDLIST: deallocating datatype address: 0x77f8e0
FREEFIELDLIST: deallocating field list address: 0x7804d8
FREEFIELDLIST: deallocating datatype address: 0x780518
FREEFIELDLIST: deallocating field list address: 0x7804f8
FREEFIELDLIST: deallocating datatype address: 0x780558
FREEFIELDLIST: deallocating field list address: 0x780538
FREEFIELDLIST: deallocating datatype address: 0x780598
FREEFIELDLIST: deallocating field list address: 0x780578
FREEFIELDLIST: deallocating datatype address: 0x780338
FREEFIELDLIST: deallocating field list address: 0x7805b8
FREEFIELDLIST: deallocating datatype address: 0x780350
FREEFIELDLIST: deallocating field list address: 0x7805d8
FREEFIELDLIST: deallocating datatype address: 0x77f908
FREEFIELDLIST: deallocating field list address: 0x7805f8
FREEFIELDLIST: deallocating datatype address: 0x780638
FREEFIELDLIST: deallocating field list address: 0x780618
FREEFIELDLIST: deallocating datatype address: 0x7033d8
FREEFIELDLIST: deallocating field list address: 0x780658
FREEFIELDLIST: deallocating datatype address: 0x77f930
FREEFIELDLIST: deallocating field list address: 0x780678
FREEFIELDLIST: deallocating datatype address: 0x780368
FREEFIELDLIST: deallocating field list address: 0x780698
FREEFIELDLIST: deallocating datatype address: 0x4dcdf8
FREEFIELDLIST: deallocating field list address: 0x7806b8
FREEFIELDLIST: deallocating datatype address: 0x70e6b8
FREEFIELDLIST: deallocating field list address: 0x7806d8
FREEFIELDLIST: deallocating datatype address: 0x779fc8
FREEFIELDLIST: deallocating field list address: 0x7806f8
FREEFIELDLIST: deallocating datatype address: 0x780738
FREEFIELDLIST: deallocating field list address: 0x780718
FREEFIELDLIST: deallocating datatype address: 0x780778
FREEFIELDLIST: deallocating field list address: 0x780758
FREEFIELDLIST: deallocating datatype address: 0x7807b8
FREEFIELDLIST: deallocating field list address: 0x780798
FREEFIELDLIST: deallocating datatype address: 0x7807f8
FREEFIELDLIST: deallocating field list address: 0x7807d8
FREEFIELDLIST: deallocating datatype address: 0x77f958
FREEFIELDLIST: deallocating field list address: 0x780818
FREEFIELDLIST: deallocating datatype address: 0x70e6e8
FREEFIELDLIST: deallocating field list address: 0x780838
FREEFIELDLIST: deallocating datatype address: 0x4dce38
FREEFIELDLIST: deallocating field list address: 0x780858
FREEFIELDLIST: deallocating datatype address: 0x703410
FREEFIELDLIST: deallocating field list address: 0x780878
FREEFIELDLIST: deallocating datatype address: 0x77f980
FREEFIELDLIST: deallocating field list address: 0x780898
FREEFIELDLIST: deallocating datatype address: 0x77f9a8
FREEFIELDLIST: deallocating field list address: 0x7808b8
FREEFIELDLIST: deallocating datatype address: 0x70e718
FREEFIELDLIST: deallocating field list address: 0x7808d8
FREEFIELDLIST: deallocating datatype address: 0x4dce78
FREEFIELDLIST: deallocating field list address: 0x7808f8
FREEFIELDLIST: field list header is now: 0x0
FREEFIELDLIST: leaving
FREEITEMLISTEX: entering
FREEITEMLISTEX: deallocating list of columns
FREEITEMLISTEX: deallocating itempos_ex address: 0x2603d10
FREEITEMLISTEX: deallocating itemretlen address: 0x25f9258
FREEITEMLISTEX: deallocating item list address: 0x780218
FREEITEMLISTEX: item list header is now: 0x0
FREEITEMLISTEX: leaving
FREEITEMLISTEX: entering
FREEITEMLISTEX: deallocating list of columns
FREEITEMLISTEX: deallocating itempos_ex address: 0x2613d14
FREEITEMLISTEX: deallocating itemretlen address: 0x25fe7b4
FREEITEMLISTEX: deallocating item list address: 0x780230
FREEITEMLISTEX: item list header is now: 0x0
FREEITEMLISTEX: leaving
PC_FREEITEMLIST: entering
PC_FREEITEMLIST: deallocating list of columns
PC_FREEITEMLIST: deallocating itemname address: 0x7117d8
PC_FREEITEMLIST: deallocating item list address: 0x703968
PC_FREEITEMLIST: item list header is now: 0x0
PC_FREEITEMLIST: leaving
FREESHMHANDLE: entering
FREESHMHANDLE: leaving
DELETEGLOBALVARS: entering
DELETEGLOBALVARS: deleting ColumnInfo global memory
DELETEGLOBALVARS: deleting ColumnInfo_Ex global memory
DELETEGLOBALVARS: deleting ColumnNames global memory
DELETEGLOBALVARS: deleting Data_ShmTokens_Tbl global memory
DELETEGLOBALVARS: deleting FetchInfo_ShmKey global memory
DELETEGLOBALVARS: leaving
CLEANUP: deallocating private_oper_area at: 0x6e1228
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_FREEOPERAREA: deallocating item list header at: 0x6e11e0
PC_FREEITEMLIST: entering
PC_FREEITEMLIST: deallocating list of columns
PC_FREEITEMLIST: deallocating itemname address: 0x6fc688
PC_FREEITEMLIST: deallocating item list address: 0x6e11e0
PC_FREEITEMLIST: item list header is now: 0x0
PC_FREEITEMLIST: leaving
PC_FREEOPERAREA: deallocating table list
PC_FREEOPERAREA: deallocating DML list
PC_FREEOPERAREA: deallocating TraceOption buffer
PC_FREEOPERAREA: deallocating TraceOption buffer at: 0x6ffa58
PC_FREEOPERAREA: deallocating PrivateLog buffer
PC_FREEOPERAREA: deallocating PrivateLog buffer at: 0x4dd960
PC_FREEOPERAREA: deallocating ConsoleInfo buffer
PC_FREEOPERAREA: deallocating ConsoleInfo buffer at: 0x4dfdb8
PC_FREEOPERAREA: deallocating ErrorInfo buffer
PC_FREEOPERAREA: deallocating ErrorInfo buffer at: 0x6fc9f0
PC_FREEOPERAREA: deallocating notify_area buffer
PC_FREEOPERAREA: deallocating notify_area buffer at: 0x4dc5f8
PC_FREEOPERAREA: deallocating OperCmdID buffer
PC_FREEOPERAREA: deallocating glblmsg
PC_FREEOPERAREA: deallocating glblmsg at: 0x3470020

Private log TWB_EVENTS:

SYBASE-TERADATA-DIRECT-LOAD- 38,17,0,OperatorEnter,Insert_Into_Tables,SYBASE_ODBC_O PERATOR,1,2013-10-30,,2,0
SYBASE-TERADATA-DIRECT-LOAD- 38,17,0,OperatorEnter,Insert_Into_Tables,TDLoad_Operat or,1,2013-10-30,,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,116,5,UtilityName,Insert_Into_Tables,TDLoad_Operato r,1,2013-10-30,TPT Inserter Operator,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,6,5,InserterVersionId,Insert_Into_Tables,TDLoad_Ope rator,1,2013-10-30,14.10.00.01,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,115,1,UtilityId,Insert_Into_Tables,TDLoad_Operator, 1,2013-10-30,4,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,154,5,InserterTdpId,Insert_Into_Tables,TDLoad_Opera tor,1,2013-10-30,192.168.72.129,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,155,5,InserterDbase,Insert_Into_Tables,TDLoad_Opera tor,1,2013-10-30,,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,157,5,InserterTableName,Insert_Into_Tables,TDLoad_O perator,1,2013-10-30,,1,1
SYBASE-TERADATA-DIRECT-LOAD- 38,166,1,InserterCheckPoint,Insert_Into_Tables,TDLoad_ Operator,1,2013-10-30,0,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,156,1,InserterTableId,Insert_Into_Tables,TDLoad_Ope rator,1,2013-10-30,1,1,1
SYBASE-TERADATA-DIRECT-LOAD- 38,157,5,InserterTableName,Insert_Into_Tables,TDLoad_O perator,1,2013-10-30,,1,1
SYBASE-TERADATA-DIRECT-LOAD- 38,158,0,InsertPhaseBegin,Insert_Into_Tables,TDLoad_Op erator,1,2013-10-30,,1,1
SYBASE-TERADATA-DIRECT-LOAD- 38,166,1,InserterCheckPoint,Insert_Into_Tables,TDLoad_ Operator,1,2013-10-30,7,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,166,1,InserterCheckPoint,Insert_Into_Tables,TDLoad_ Operator,1,2013-10-30,7,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,159,0,InsertPhaseEnd,Insert_Into_Tables,TDLoad_Oper ator,1,2013-10-30,,1,1
SYBASE-TERADATA-DIRECT-LOAD- 38,160,1,InserterRowsSent,Insert_Into_Tables,TDLoad_Op erator,1,2013-10-30,7,1,1
SYBASE-TERADATA-DIRECT-LOAD- 38,161,1,InserterRowsInserted,Insert_Into_Tables,TDLoa d_Operator,1,2013-10-30,7,1,1
SYBASE-TERADATA-DIRECT-LOAD- 38,18,1,OperatorExit,Insert_Into_Tables,SYBASE_ODBC_OP ERATOR,1,2013-10-30,17170436,2,0
SYBASE-TERADATA-DIRECT-LOAD- 38,162,0,InserterSessEnd,Insert_Into_Tables,TDLoad_Ope rator,1,2013-10-30,,1,0
SYBASE-TERADATA-DIRECT-LOAD- 38,18,1,OperatorExit,Insert_Into_Tables,TDLoad_Operato r,1,2013-10-30,0,1,0

Private log load_log:

 
     ====================================================== =============
     =                                                                 =
     =                  TERADATA PARALLEL TRANSPORTER                  =
     =                                                                 =
     =          SQL INSERTER OPERATOR     VERSION 14.10.00.01          =
     =                                                                 =
     =          OPERATOR SUPPORT LIBRARY VERSION 14.10.00.01           =
     =                                                                 =
     = COPYRIGHT 2001-2013, TERADATA CORPORATION. ALL RIGHTS RESERVED. =
     =                                                                 =
     ====================================================== =============

**** 15:25:38 Processing starting at: Wed Oct 30 15:25:38 2013
 
     ====================================================== =============
     =                                                                 =
     =                      Module Identification                      =
     =                                                                 =
     ====================================================== =============

     SQL Inserter Operator for Windows on WUSMM255065-H2T
     InsMain    : 14.10.00.03
     InsCLI     : 14.10.00.04
     InsUtil    : 14.10.00.06
     PcomCLI    : 14.10.00.31
     PcomMBCS   : 14.10.00.02
     PcomMsgs   : 14.10.00.02
     PcomNtfy   : 14.10.00.05
     PcomPx     : 14.10.00.10
     PcomUtil   : 14.10.00.09
     PXICU      : 14.10.00.01
     TDICU      : 14.10.00.00
     CLIv2      : 14.10.00.03  
 
     ====================================================== =============
     =                                                                 =
     =                   Control Session Connection                    =
     =                                                                 =
     ====================================================== =============

**** 15:25:38 Connecting to RDBMS:    '192.168.72.129'
**** 15:25:38 Connecting with UserId: 'dbc'
**** 15:25:38 Retrieving the Teradata Database retryable error codes
**** 15:25:38 The RDBMS retryable error code list was not found
**** 15:25:38 The job will use its internal retryable error codes
 
     ====================================================== =============
     =                                                                 =
     =                  Teradata Database Information                  =
     =                                                                 =
     ====================================================== =============

**** 15:25:38 Teradata Database Version:      '14.00.00.01                     '
**** 15:25:38 Teradata Database Release:      '14.00.00.01                   '
**** 15:25:38 Maximum request size supported: 1MB
**** 15:25:38 Session character set:          'ASCII'
**** 15:25:38 Data Encryption:                supported
**** 15:25:38 Enhanced Statement Status:      not supported by RDBMS
 
**** 15:25:38 Creating insert request for the job
     USING au_id(VARCHAR(36)) INSERT INTO SUPPLIER_STG.BLURBS(au_id) values(    :au_id );
 
     ====================================================== =============
     =                                                                 =
     =                     Column/Field Definition                     =
     =                                                                 =
     ====================================================== =============

     Column Name                    Offset Length Type     
     ============================== ====== ====== ========================
     au_id                               0     36 VARCHAR
     ============================== ====== ====== ========================
     INDICATOR BYTES NEEDED: 1
     EXPECTED RECORD LENGTH: 39
**** 15:25:38 Checkpoint complete. Rows inserted: 0
 
     ====================================================== =============
     =                                                                 =
     =                           Load Phase                            =
     =                                                                 =
     ====================================================== =============

**** 15:25:39 Starting to send data to the RDBMS
**** 15:25:40 Checkpoint complete. Rows inserted: 7
**** 15:25:41 Checkpoint complete. Rows inserted: 7
**** 15:25:42 Finished sending rows to the RDBMS
 
              Instance    Rows Sent             Rows Inserted
              ========  ====================  ====================
                  1                        7                     7
              ========  ====================  ====================
                Total                      7                     7
 
**** 15:25:42 Number of bytes sent to the RDBMS for this job: 123
 
**** 15:25:42 Load Phase statistics:
Elapsed time: 00:00:00:03 (dd:hh:mm:ss)
CPU time:     0.0156001 Second(s)
MB/sec:       0.000
MB/cpusec:    0.008
 
     ====================================================== =============
     =                                                                 =
     =                        Logoff/Disconnect                        =
     =                                                                 =
     ====================================================== =============

**** 15:25:42 Logging off all sessions
 
              Instance      Cpu Time    
              ========  ================
                   1        0.37 Seconds
 
**** 15:25:43 Total processor time used = '0.374402 Second(s)'
.        Start : Wed Oct 30 15:25:38 2013
.        End   : Wed Oct 30 15:25:43 2013
.        Highest return code encountered = '0'.
**** 15:25:43 This job terminated

feinholz 1234 posts Joined 05/08
31 Oct 2013

In the target table, how many rows are there?
What are the contents of that target table?
Please show the contents of a SELECT against the source table and target table so we can see what is going on.
And thank you for providing the trace output!!
Thanks!
 

--SteveF

M.M@TD 16 posts Joined 03/13
31 Oct 2013

Thanks for the response !
The Target Table was initially empty.The table consists of one VARCHAR(36) and one CLOB column on Teradata side.
And on Source side (Sybase), it corresponds to ID & TEXT.
I see one of the row got duplicated.Couldn't firgure out why ?
After the second run,I saw each row got duplicated on Teradata side.i.e 6 exported and 12 loaded.
I have modified the data now.Do you want me to do a fresh run and paste the output here .
Please let me know .
 

feinholz 1234 posts Joined 05/08
31 Oct 2013

Actually hold off. We see the problem inhouse and are investigating.
Thanks!

--SteveF

M.M@TD 16 posts Joined 03/13
31 Oct 2013

Thanks for being so responsive !

M.M@TD 16 posts Joined 03/13
20 Nov 2013

I wanted to add something here.
I don't have DataDirect installed.I am defining the sybase connection using ODBC driver from Teradata only.And specifying the same DSN in TPT script.

feinholz 1234 posts Joined 05/08
20 Nov 2013

What ODBC driver from Teradata?
Teradata's ODBC driver is only to be used against Teradata.
 

--SteveF

M.M@TD 16 posts Joined 03/13
21 Nov 2013

I defined the ODBC connection in SQL Assitant using Sybase ASE driver.And used the same DSN in TPT script to connect to Sybase ASE database
 

feinholz 1234 posts Joined 05/08
21 Nov 2013

Ah, ok it is not an ODBC driver from Teradata.
We only certify with DataDirect, but this is not the cause of the issue.
We are still looking into it.

--SteveF

You must sign in to leave a comment.