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

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:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Data Studio
Database Administration

Software version:

3.1, 3.1.1, 3.2

Operating system(s):

AIX, HP-UX, Linux, Linux zSeries, Solaris, Windows

Reference #:

1614963

Modified date:

2013-11-21

Translate my page

Machine Translation

Content navigation