Do we need any Privileges to create Imagecpy of a talble

mkk157 · Active User Joined: 17 May 2006 Posts: 310

Hi,

As part of testing of my project, I need to take the Imagecopy of the table. and this is one time activity.

What are all required to achieve this.

It would be grateful If anybody provide me the link to the manual.

I hardly need this to ove further.

I have Read access on all the tables exists in the particulat tablespace. do I need any other for this?

dick scherrer · Posted: Fri Apr 11, 2008 10:56 am

Hello,

I'd suggest you communicate with the database support people for your environment. They can tell you how this is done on your system and probably provide you with everything you need.

mkk157 · Active User Joined: 17 May 2006 Posts: 310

Exactly Dick,

I am able to write the code for the same and I got the following error
racf-id DOES NOT HAVE SUFFICIENT PRIVILEGES TO EXECUTE COPY ON DATABASE database-name

Actaully the problem is the DBA who is allocated to our project is not available to at the moment, I want to do this anyway to continue my testing.

I talk to support people with the same error i got and i explained them the imortance of the environment requirement. And they responded positively.

thanks very much dick.

dick scherrer · Posted: Fri Apr 11, 2008 12:55 pm

You're welcome

d

Prajesh_v_p · Active User Joined: 24 May 2006 Posts: 133 Location: India

If you have access to Catalogue table SYSDBAUTH, probably you will be able to check out whether you have image copy access:

IMAGCOPYAUTH CHAR(1) NOT NULL
Whether the GRANTEE can use the COPY, MERGECOPY, MODIFY, and QUIESCE utilities on the database:

blank Privilege is not held
G Privilege held with the GRANT option
Y Privilege is held without the GRANT option

From the link:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sysibmsysdbauthtable.htm

Thanks,
Prajesh