Database objects cannot be copied from one DB2 for Linux, UNIX, and Windows database and pasted into another DB2 for Linux, UNIX, and Windows database
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.
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
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.
More support for:
IBM Data Studio
Software version: 3.1, 3.1.1, 3.2
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1614963
Modified date: 02 February 2014