Reason:
The xxx, yy, and zzz in the message text are the SQLCODE, CA Datacom/DB return code, and its internal return code that indicate the cause of the original Temporary Table Manager (TTM) area initialization failure. The xxx is not -157 (it matches the code that appeared in the -157 return code).
The SQLSTATE that equates to this SQL return code is 58S02.
Action:
Correct the problem that caused the TTM initialization failure.
When a TTM initialization fails, the initialization is re-tried on every subsequent attempt to use the TTM until the initialization succeeds. A return code of -35 is generated each time an attempt fails. This means that when the problem preventing the initialization is fixed, the TTM can become useable again without your having to cycle the Multi-User Facility. However, because this automatic re-trying of TTM initialization only becomes activated when TTM initialization fails, the initialization is not re-tried when the TTM is in use, meaning that subsequent problems are not detected.
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.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|