Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

old db2 tablespace names in HR SP22 error log

Hi all,

We are applying HR support packages on a test box. This test instance is a copy of our production ERP instance. The copy was done using a backup/restore off the PRD database.

We get an error when applying SAPKE60020 because it is trying to create a table in a tablespace that does not exist. The tablespaces it is trying to access are of the pattern PRD#STABD, PRD#POOLD etc. PRD is copied to TST.

I have updated tables TADB6, TSDB6 and IADB6 and changed PRD to TST for all tablespaces. At the OS level if I run a "db2 list tablespaces" all the names show up as TST#<tablespacename>.

I am not sure why it is trying to access PRD#<tablespace>. Is there someplace else I need to make a change from the old name?

Thanks,

Kevin

Former Member
replied

Hi Kevin,

some transports insert DDL statements into table TATAF for mass generation before executing them. You may check if this TABLE contains entries with the old tablespace names.

Regards

Frank

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question