|
View previous topic :: View next topic
|
| Author |
Message |
dsivtina
New User
Joined: 05 Feb 2008
Posts: 5
Location: chennai
|
|
|
|
Hi,
I need to free/overwrite an existing plan which was created by some other user. I don't have to access to free that plan. How can i do this?
Thanks in advance. |
|
| Back to top |
|
 |
Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
Location: chennai
|
|
|
|
Get the access from someone who can grant. Or get it freed from them.  |
|
| Back to top |
|
|
dsivtina
New User
Joined: 05 Feb 2008
Posts: 5
Location: chennai
|
|
|
|
| It can't be done, since that User id is revoked. |
|
| Back to top |
|
|
Gousiya Mulla
New User
Joined: 02 Jun 2008
Posts: 87
Location: Bangalore
|
|
|
|
Try contacting your DB Support guys!
Cheers .. |
|
| Back to top |
|
|
nagesh54
New User
Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad
|
|
|
|
Hi,
DBA will have access to free the plans . Please contact your DBA for this.
Thanks and Regards,
Nagesh. |
|
| Back to top |
|
|
satyender
New User
Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA
|
|
|
|
dsivtina,
Goto DB2I panel ->option 5
You will find all the options like BIND PLAN, REBIND PLAN, FREE PLAN etc. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Quote: |
| You will find all the options like BIND PLAN, REBIND PLAN, FREE PLAN etc. |
This is no differnt then "FREE" which probably dsivtina, was using through BMC. And if you look into that option, such as shown below
| Code: |
FREE PLAN SSID: DB2D
COMMAND ===> ________________________________________________________________
Enter plan name(s) to be freed:
1 PLAN NAME ................. ===> ________ (* to free all authorized plans)
2 ADDITIONAL PLANS? ......... ===> NO (Yes to include more plans) |
You'll find, this will work only for "authorized" plans so it won't for the request from OP as s/he said,
| Quote: |
| It can't be done, since that User id is revoked. |
Having said that, I would like to believe by "revoked" s/he means "USER ID RACFID IS NOT ON FILE" because for revoked ID there is usually (always) a process in place to get them active.  |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
To resolve it:
1. Get in contact with your DBA, as suggested earlier.
2. If you have Jobtrac (sheduler) availble at your shop -- run a job using sheduler to "free" the plan. Schduler, usually, have access to execute such jobs successfully. (at least at my current shop...) |
|
| Back to top |
|
|
|
|
