TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

Tools & Utilities
M_M
Teradata Employee

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_OPERATOR,1,2013-10-30,,2,0

SYBASE-TERADATA-DIRECT-LOAD-38,17,0,OperatorEnter,Insert_Into_Tables,TDLoad_Operator,1,2013-10-30,,1,0

SYBASE-TERADATA-DIRECT-LOAD-38,116,5,UtilityName,Insert_Into_Tables,TDLoad_Operator,1,2013-10-30,TPT Inserter Operator,1,0

SYBASE-TERADATA-DIRECT-LOAD-38,6,5,InserterVersionId,Insert_Into_Tables,TDLoad_Operator,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_Operator,1,2013-10-30,192.168.72.129,1,0

SYBASE-TERADATA-DIRECT-LOAD-38,155,5,InserterDbase,Insert_Into_Tables,TDLoad_Operator,1,2013-10-30,,1,0

SYBASE-TERADATA-DIRECT-LOAD-38,157,5,InserterTableName,Insert_Into_Tables,TDLoad_Operator,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_Operator,1,2013-10-30,1,1,1

SYBASE-TERADATA-DIRECT-LOAD-38,157,5,InserterTableName,Insert_Into_Tables,TDLoad_Operator,1,2013-10-30,,1,1

SYBASE-TERADATA-DIRECT-LOAD-38,158,0,InsertPhaseBegin,Insert_Into_Tables,TDLoad_Operator,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_Operator,1,2013-10-30,,1,1

SYBASE-TERADATA-DIRECT-LOAD-38,160,1,InserterRowsSent,Insert_Into_Tables,TDLoad_Operator,1,2013-10-30,7,1,1

SYBASE-TERADATA-DIRECT-LOAD-38,161,1,InserterRowsInserted,Insert_Into_Tables,TDLoad_Operator,1,2013-10-30,7,1,1

SYBASE-TERADATA-DIRECT-LOAD-38,18,1,OperatorExit,Insert_Into_Tables,SYBASE_ODBC_OPERATOR,1,2013-10-30,17170436,2,0

SYBASE-TERADATA-DIRECT-LOAD-38,162,0,InserterSessEnd,Insert_Into_Tables,TDLoad_Operator,1,2013-10-30,,1,0

SYBASE-TERADATA-DIRECT-LOAD-38,18,1,OperatorExit,Insert_Into_Tables,TDLoad_Operator,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

8 REPLIES
Teradata Employee

Re: TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

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
Teradata Employee

Re: TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

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 .

Teradata Employee

Re: TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

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

Thanks!

-- SteveF
M_M
Teradata Employee

Re: TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

Thanks for being so responsive !

M_M
Teradata Employee

Re: TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

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.

Teradata Employee

Re: TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

What ODBC driver from Teradata?

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

-- SteveF
M_M
Teradata Employee

Re: TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

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

Teradata Employee

Re: TPT ODBC Operator: 6 rows exported from source , 7 rows loaded into Teradata -- Weird

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