on 12-12-2018 8:34 AM
Hello SAP friends,
I am right doing an EHP8 Upgrade on our system with ERP 6.0 EHP6 on NW 7.0 EHP3.
The underlying database is DB2 10.5
I am now in phase MAIN_SHDRUN/SUBMOD_RRC_TRIGGER_DEFAULT/SQLRUNTASK_RRC_TRIGGERS
SUM has thrown an error telling me the following:
ERROR: The following errors were detected in the log files:
# /usr/sap/SUM/abap/log/SQLRUN_RRC-TRIGGERS_09.T50:
3 ETQ398 SQL: SET CURRENT LOCK TIMEOUT 5
2 ETQ399 Executing group 28563 sequence 8 for 'TIVFBKLAT--CRE_TRIG':
3 ETQ398 SQL: LOCK TABLE "TIVFBKLAT" IN EXCLUSIVE MODE
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20181205144848
1EETQ008 Error message: DBSL error 99 (db code -960): 1EETQ008 SQL0960C The maximum number of objects have been created in the table spaces with the following names or identifiers "T50#POOLD". SQLSTATE=57011
4 ETQ399 Rollback.
1EETQ008 Error message: DBSL error 99 (db code -960):
1EETQ009XSQL0960C The maximum number of objects have been created in the table
1EETQ009Xspaces with the following names or identifiers "T50#POOLD".
1EETQ009XSQLSTATE=57011
For I am not an DB2 expert I have contacted SAP Support. They forwarded my incident to DB6 Team. First they told me to use DB6CONV tool. Unfortunately this tool is not installed on the system. So I tried. But when trying to do this a dump raised with the same error as SUM did. Then they were telling me to try to install it via command line. No success. Error: system in upgrade, no import possible.
I tried to unlock the system using SAPup unlocksys and retried the command for installing the transport manually. Still the same error. I am not able to install DB6CONV at this moment.
Next they where asking if I could check to convert to virtual tables. I really don't understand the context between "maximum number of objects" and "virtual tables".
Anyway... I crosschecked the tables mentioned in the SUM error with DBACOCKPIT. All the tables are already virtual tables. So this solution suggestion is useless again.
I am growing desperate. The DB6 team is unable to help me out.
Any ideas on how to solve the problem?
Regards
Henning
Hello Juan,
thanks for your reply. This note was given to me by SAP as well. It is not working for my incident.
1) DB6CONV cannot be installed --> dump raises with same error as SUM
2) Convertion to virtual tables --> Mentioned tables in SUM error are actually virtual tables
I assume that SAP DB6 team is experienced in DB2 and that all supporters are DB2 admins.
Currently they are not able to help me.
Regards, Henning
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Henning,
Solution is explained on SAP Note 1778732 - SQL0960C The maximum number of objects encountered in DBCLONE phase
You need to get a DB2 admin on the case
Regards, JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.