Previous Topic: -156 - VIEW xxx WITH CHECK OPTION VIOLATIONNext Topic: -158 - CANNOT CREATE SYNONYM FOR INVALID VIEW aaaa


-157 - TTM INIT. FAILED. SQL CODE xxx, DB RC yy(zzz).

Reason:

The Temporary Table Manager (TTM) area was not properly set up during system installation or has been damaged. This SQLCODE is triggered by a CA Datacom/DB return code, so use the displayed return code and internal return code to determine the specific problem.

The xxx, yy, and zzz in the message text are the SQLCODE, CA Datacom/DB return code, and internal return code that are triggering the TTM initialization failure. After you receive this error message any attempt to access the TTM during this execution of the Multi-User Facility returns an SQLCODE -35 until the problem causing the failure is fixed. See the information included with SQLCODE -35 in -35 - TTM IS UNUSABLE: SQLCODE xxx, DB RC yy(zzz) ON INITIALIZATION.

The SQLSTATE that equates to this SQL return code is 58S01.

Action:

Take action based on the CA Datacom/DB return code. See CA Datacom/DB Return Codes for an explanation of the return code. See the TTM installation instructions and make sure that the TTM area has been properly set up.

Note: If the CA Datacom/DB return code is reported as 10(39), print a Directory (CXX) report for your TTM database and check the DIRECT attribute for the key (there is only one key) on the TTM table. If DIRECT=NO, you have found the cause of your problem. You can correct this problem by updating the key definition to reflect DIRECT=YES and recataloging the database.