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
