Phil, something similar happened to us a while back. I don't remember if it was reason code 7, but here's what I wrote up when we figured out how to fix it:
*** If you get the SQL2048N An error occurred while accessing object "SQL PROCEDURE FILES" message, here's what you do: 1) go to the $HOME/sqllib/function/routine/sqlproc directory. This directory contains one subdirectory per database in the instance (that has Stored Procedures defined). 2) cd to the directory for the database that's having the problem 3) ls -lrtR to find which "tmp" subdirectory is not empty 4) empty out that "tmp" directory. you may have to remove it entirely. You probably need to do a db2stop/db2start, too. *** It may not be applicable to your case, but I thought I'd send it over just in case. cheers, /T Tomas Hallin Database Administration Robert Half International Pleasanton, CA -----Original Message----- From: db2it [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 4:11 AM To: DB2EUG Cc: DB2-L Subject: [DB2EUG] Redirected Restore of DB with SQL SPs Ran into a problem doing a redirected restore of a database with SQL stored procedures. On our production server database DPXXX001 has a number of SQL stored procedures defined. After installing a new release into production I want to create another copy of this onto our test box using name DTXXX001. I do a redirected restore, which completes successfully. However when I try to connect to the restored database I get - SQL2048N An error occurred while accessing object "SQL PROCEDURE FILES" Reason code "7". I tried putting back the original database (from a backup which I had just taken) but was getting similar problems. Eventually I had to db2look / db2move the database from production into an empty database on our test server, and then manually recreate the stored procedures. We are DB2 V7.2 Fixpack 7 on AIX 4.3.3. Phil - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
