Read operation failure. >

[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.

[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. >

[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. >

[ray.wurlod]

What happened to Sunoj? Now need to think about this, meanwhile what does your official support provider have to say?

[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.

[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.

[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.

[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.

[Sunoj]

Thank you Ray for your support. We were able to solve the problem.