Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Code: Select all
SELECT &SAVEDLISTS& WITH @ID LIKE "&&..."
DELETE &SAVEDLISTS&
The second command will prompt you to delete with active Select List. Answer "Yes" to this question.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
sia_999
- Premium Member
- Posts: 18
- Joined: Mon Feb 12, 2007 3:21 am
- Location: Riyadh
Post
by sia_999 »
as per your instructions we have delete the savedlists, but still it gave same Read operation faile
>SELECT &SAVEDLISTS& WITH @ID LIKE "&&..."
27 record(s) selected to SELECT list #0.
>>
>>DELETE &SAVEDLISTS&
You have an active SELECT list.
Do you wish to DELETE the records previously SELECTed?
The first record ID = "&&S.dsadm.12".
Enter Y or N: y
27 records DELETEd.
>LOGTO EDWPROD
Read operation failure. >
ilyas
-
sia_999
- Premium Member
- Posts: 18
- Joined: Mon Feb 12, 2007 3:21 am
- Location: Riyadh
Post
by sia_999 »
as per your instructions we have delete the savedlists, but still it gave same Read operation faile
>SELECT &SAVEDLISTS& WITH @ID LIKE "&&..."
27 record(s) selected to SELECT list #0.
>>
>>DELETE &SAVEDLISTS&
You have an active SELECT list.
Do you wish to DELETE the records previously SELECTed?
The first record ID = "&&S.dsadm.12".
Enter Y or N: y
27 records DELETEd.
>LOGTO EDWPROD
Read operation failure. >
ilyas
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
What happened to Sunoj? Now need to think about this, meanwhile what does your official support provider have to say?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
sia_999
- Premium Member
- Posts: 18
- Joined: Mon Feb 12, 2007 3:21 am
- Location: Riyadh
Post
by sia_999 »
Sunoj is busy with management work, here in middle east we have official support with IBM-SBM but we do not get any support from them.
ilyas
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
If you are paying for official support then you have a strong moral argument (and probably a legal argument as well) to demand that support.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
sia_999
- Premium Member
- Posts: 18
- Joined: Mon Feb 12, 2007 3:21 am
- Location: Riyadh
Post
by sia_999 »
I am glad to update you that , the Read operation failure has fixed by doing the below steps.
fixtool -fix -file UV_SCHEMA
Filename: UV_SCHEMA
Start Diagnostics.
0 Errors found in physical structure.
1 Errors found in file header.
3 Errors found in file groups.
2 Other errors found in file.
5 records processed.
6 Errors on file.
Start Fixing.
An error has occurred when running.
Error: An incorrect group number has been specified
2 Errors fixed.
Fixtool Completed.
Thanks Ray for your usual support.
ilyas
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Glad you found it. I was next going to suggest fixtool on UV.ACCOUNT, and only after that on the SQL Catalog tables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
Sunoj
- Participant
- Posts: 10
- Joined: Sat May 20, 2006 6:03 am
Post
by Sunoj »
Thank you Ray for your support. We were able to solve the problem.
Sunoj Thomas
ARAB NATIONAL BANK-HEAD OFFICE
Annex Building IInd Floor(BSD)
P.O BOX 56921
RIYADH -11564
Mob:00966-502573856
Office:00966-1-4029000X4294