IBM Support

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

Troubleshooting


Problem

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

[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database Administration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"3.1;3.1.1;3.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21614963