What is DataStage Panthom?

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

What is DataStage Panthom?

Post by admin »

** High Priority **


a phantom is an error that will not cause the job to abort it is a warning =
error not fatal it could be caused by passing a "character" value to an =
"integer for example you can trace the error by looking in the error log =
on your system.
have nice day
>>> kcbland_2000@yahoo.com Friday, January 09, 2004 15:29 >>>
Your job attempted to write a row to a hash file with
a NULL value in the primary key. Either put a
constraint on the link to the hash file to prevent
doing this, or correct the derivation for the primary
key column to longer allow a NULL value.

-Ken



--- Venkat wrote:
> Hey Gurus,
>=20
> Pls let me know What is Panthom Error? I've searched
> in DataStage Documentation and but I helpless. Pls
> clarify my query. And Im getting one of the
> following error with Panthom.
>=20
> Project:Ex ()
> Job name:jxxxMisc
> Event #:613
> Timestamp:1/9/2004 2:40:58 AM
> Event type:Warning
> User:adm
> Message:
> DataStage Job 943 Phantom 12049
> Program "DSD.UVClose": Line 55, Attempted WRITE with
> NULL record ID
> DataStage Phantom Finished
>=20
> Where do I find this error? In what cases it will
> give Panthom Errors/Warnings? What is the procedure
> to rectify these errors?=20
> Sorry Im not very close to DataStage
> Troubleshooting. Pls give me ur Suggestions and
> Solutions? Thanx in Advance.
>=20
>=20
> Thanx and Regards,
> Venkat.


__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

Georges Daher=20
Analyst Programmer=20
Solutions Delivery Unit
IT Department
Banque AUDI S.A.L.
Direct No : 977467 /Ext. : 1467
Fax : 961 1 980210 /Po.Box 11-2560
E-mail :Georges.Daher@audi.com.lb
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

What is DataStage Panthom?

Post by admin »

Your job attempted to write a row to a hash file with
a NULL value in the primary key. Either put a
constraint on the link to the hash file to prevent
doing this, or correct the derivation for the primary
key column to longer allow a NULL value.

-Ken



--- Venkat wrote:
> Hey Gurus,
>
> Pls let me know What is Panthom Error? I've searched
> in DataStage Documentation and but I helpless. Pls
> clarify my query. And Im getting one of the
> following error with Panthom.
>
> Project:Ex ()
> Job name:jxxxMisc
> Event #:613
> Timestamp:1/9/2004 2:40:58 AM
> Event type:Warning
> User:adm
> Message:
> DataStage Job 943 Phantom 12049
> Program "DSD.UVClose": Line 55, Attempted WRITE with
> NULL record ID
> DataStage Phantom Finished
>
> Where do I find this error? In what cases it will
> give Panthom Errors/Warnings? What is the procedure
> to rectify these errors?
> Sorry Im not very close to DataStage
> Troubleshooting. Pls give me ur Suggestions and
> Solutions? Thanx in Advance.
>
>
> Thanx and Regards,
> Venkat.


__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

What is DataStage Panthom?

Post by admin »

"Phantom" is merely DataStage terminology for "background process". Each job, and each active stage in a job, may run as a separate background process. This is why it is a "phantom" that has generated the error.

Other posters have addressed the actual error.
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked