DB2 table is not been shown in the thick client (V9.5.0.7)

[akstrom]

I have an AG with the internal DB2 name MCA.
MCA has 6 tables : MCA1, MCA2, MCA3, MCA4, MCA5 and MCA6.
When searching in the Client (thick Client installed on the computer) the customer and I cannot find any documents from MCA5, but we can find documents from all of the other tables (of course I have only searched for a few documents in all of the tables)

It looks like the table MCA5 has lost contact with the client, but we find all the documents when we search directly inside DB2

How can we �connect� the table again to CMOD so it can be searchable again for the client ?

[Ed_Arnold]

That's a new one on me.

If no helpful replies soon, a PMR is in order.

Ed

[Stephen McNulty]

is there anything different with permissions for table MCA5 compared to the others?

[Justin Derrick]

Sounds like the record for MCA5 in the arsseg table is damaged / deleted / incorrect.

-JD.

[akstrom]

I opened up a PMR and got back a hole bunch of db2 Select command that gave me a document that looks like is the problem (a none valid date even though it looks ok.)
We are askin the customer to chec the date and if it is ok by them we have a command to change it to a valid date.

Thanks for all answers !

[Justin Derrick]

Yeah, we had a line-of-business system send us files with the date 2115-12-31.  It caused us a LOT of problems - obviously, the users said the documents were "missing", and suddenly the performance of the Application Group was terrible.  We check our loads for dates more than a year into the future now.

-JD.