IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00C90206

JITINDER CHOUDHARY

IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00C90206

Hi All,

I need to create non-unique index but my mistake I created unique index in production. Is there any impact of this on clean up job. Functionality of the job that is falling is as below.

SELECTSCANCELLED VERSION OF THE PRODUCTS & RSTATE FOR
A MONTH OLD FROM CURRENT MONTH FROM PITCVPR AND BASED
THE RECORDSON ALL THE TABLES PITCVDL,PITCVDC PITTREQ
DEL THE VERSIONS AND KEEP A NECCESSARY BACKUP BEFORE
GOING TO DEL THE RECORDS

job failed with below Error:-
.IKJ56644I NO VALID TSO USERID, DEFAULT USER ATTRIBUTES USED
.READY
.DSN SYSTEM(DB2C)
.DSN
.RUN PROG(PIPBW97) LIB('WAP300PB.PI.LOADLIB') PLAN(PIPBT90P)
.IKJ56641I DSN ENDED DUE TO ERROR+
.IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00C90206

Please suggest on this issue as this issue related to unique index creation.

Raymond Bell

IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00C90206
(in response to JITINDER CHOUDHARY)
I resisted last time, but a person can only take so much.

http://lmgtfy.com/?q=00C90206

Pay attention to the Problem Determination section and follow the instructions.

Get yourself copies of the DB2 reference manuals, either in PDF format or via the Knowledge Centre – which the above search found first. ‘Codes’ will describe 00C90206 and where to start looking.

Physician, heal thyself. :o)

Cheers,


Raymond

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: JITINDER CHOUDHARY [mailto:[login to unmask email]
Sent: 05 October 2017 15:13
To: [login to unmask email]
Subject: [DB2-L] - IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00C90206


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************


Hi All,

I need to create non-unique index but my mistake I created unique index in production. Is there any impact of this on clean up job. Functionality of the job that is falling is as below.

SELECTSCANCELLED VERSION OF THE PRODUCTS & RSTATE FOR
A MONTH OLD FROM CURRENT MONTH FROM PITCVPR AND BASED
THE RECORDSON ALL THE TABLES PITCVDL,PITCVDC PITTREQ
DEL THE VERSIONS AND KEEP A NECCESSARY BACKUP BEFORE
GOING TO DEL THE RECORDS

job failed with below Error:-
.IKJ56644I NO VALID TSO USERID, DEFAULT USER ATTRIBUTES USED
.READY
.DSN SYSTEM(DB2C)
.DSN
.RUN PROG(PIPBW97) LIB('WAP300PB.PI.LOADLIB') PLAN(PIPBT90P)
.IKJ56641I DSN ENDED DUE TO ERROR+
.IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00C90206

Please suggest on this issue as this issue related to unique index creation.

-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com