Technote (troubleshooting)
Problem(Abstract)
An error occurs after you copy database objects in a DB2 for Linux, UNIX, and Windows database and try to paste the objects into another DB2 for Linux, UNIX, and Windows database.
Symptom
An error similar to the following one is returned after you specify the the options to copy the database objects into the target database:
A table space could not be found with a page size of at least "4096" that authorization ID "DB2USER" is authorized to use. SQLCODE=-286, SQLSTATE=42727, DRIVER=4.14.113
Cause
Copying and pasting database objects that contain data from one database into another database requires a temporary table space on the target database. The database user copying the database objects to the target database does not have USE privilege on a temporary table space of the appropriate size.
Resolving the problem
The following methods give the database user access to a temporary table the appropriate size in the target database:
- The user creates a temporary table space in the target database.
- An administrator grants the user USE privilege on a temporary table space in the target database.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.