Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Do we need any Privileges to create Imagecpy of a talble

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Fri Apr 11, 2008 10:38 am    Post subject: Do we need any Privileges to create Imagecpy of a talble
Reply with quote

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?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Apr 11, 2008 10:56 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Fri Apr 11, 2008 11:46 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Apr 11, 2008 12:55 pm    Post subject: Reply to: Do we need any Privileges to create Imagecpy of a
Reply with quote

You're welcome icon_smile.gif

d
Back to top
View user's profile Send private message
Prajesh_v_p

Active User


Joined: 24 May 2006
Posts: 133
Location: India

PostPosted: Fri Apr 11, 2008 2:17 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to create issuer certificate? :'( vasanthz All Other Mainframe Topics 1 Sat Nov 18, 2017 5:14 am
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
This topic is locked: you cannot edit posts or make replies. rexx to create a tso command Bharath Vikraman CLIST & REXX 1 Tue Aug 08, 2017 3:32 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us