cancel
Showing results for 
Search instead for 
Did you mean: 

EHP8 Upgrade - MAIN_SHDRUN - Maximum number of objects have been created

charminghm
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

charminghm
Discoverer
0 Kudos

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

JPReyes
Active Contributor
0 Kudos

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