TPT Script Error While executing

Database

TPT Script Error While executing

Hi,

I am getting below TPT error while reading from MQ 

MQ_READER[1]: TPT19434 pmOpen failed. General failure (34): 'Teradata Websphere MQ AMOD/PIDMMain(!ERROR!).  --ERROR: Ignoring unnecessary pathname specification at open'

MQ_READER[1]: TPT19304 Fatal error opening file.

MQ_READER[1]: TPT19015 TPT Exit code set to 12.

STREAM_OPERATOR: TPT1508 RDBMS error 3802:Database 'PROD_CURRENT_LIB' does not exists

STREAM_OPERATOR: The job will use its internal data-related erro codes

Please find the code also

DEFINE JOB MQ_LOAD

DESCRIPTION 'Load a Teradata table using MQSeries'

(

DEFINE SCHEMA MQ_SCHEMA

(

MESSAGEPAYLOAD CHAR(117)

);

DEFINE OPERATOR MQ_READER

TYPE DATACONNECTOR PRODUCER

SCHEMA MQ_SCHEMA

ATTRIBUTES

(

VARCHAR PrivateLogName = 'dataconnector_log',

VARCHAR FileName = 'c:/1.txt',

VARCHAR Format = 'unformatted',

VARCHAR IndicatorMode = 'N',

VARCHAR OpenMode = 'Read',

VARCHAR AccessModuleName = 'libmqs.so',

VARCHAR AccessModuleInitStr = '-qnm NOTIFICATION -qmgr AA -TRCL 4 MQTRACE -CKFILE CKFILE'

);

DEFINE OPERATOR STREAM_OPERATOR

TYPE STREAM

SCHEMA *

ATTRIBUTES

(

VARCHAR PrivateLogName = 'stream_log',

VARCHAR TdpId = ,

VARCHAR UserName =,

VARCHAR UserPassword = ,

VARCHAR LogTable = 'DEV1_DB.tst_LOG',

VARCHAR ErrorTable = 'DEV1_DB.tst_ET'

);

APPLY

('INSERT INTO DEV1_DB.MQ_DATA_tst VALUES(:MESSAGEPAYLOAD);')

TO OPERATOR (STREAM_OPERATOR[2])

SELECT * FROM OPERATOR (MQ_READER[2]);

Please advise any changes i need to make to the script

Thanks

Mohan

1 REPLY
Enthusiast

Re: TPT Script Error While executing

I have fixed the above issue by adding Region=0M in JCL.

 

Am am getting TPT19015 TPT Exit code set to 12 and my target and error tables locked. Please help me to sort out this issue