cancel
Showing results for 
Search instead for 
Did you mean: 

Missing SYSTABLES from my database.

Former Member
0 Kudos

We are suddenly experiencing dumps in our system and they are saying the tables do no exist. The tables are physically in the database on the OS side. When investigating I find that SYSTABLES is missing from my database along with SYSCST. Has anyone experienced this and is there a way of rebuilding. I cannot refresh from production because we are mid upgrade. This was not an issue after the upgrade we had tested for 5 weeks and everything was fine. Somehow they have disappeared. Any help would be greatly appreciated.

Tania

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Tania,

Please check Note 66985.

Basically execute the following commands

CALL PGM(QSYS2/QSQXRLF) PARM('DLT' 'R3<SID>DATA')

CALL PGM(QSYS2/QSQXRLF) PARM('CRT' 'R3<SID>DATA')

Best regards,

Victor