Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to Free Bind Plan's created by others?

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

New User


Joined: 05 Feb 2008
Posts: 5
Location: chennai

PostPosted: Thu Jul 16, 2009 1:22 pm    Post subject: How to Free Bind Plan's created by others?
Reply with quote

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

Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Thu Jul 16, 2009 1:32 pm    Post subject:
Reply with quote

Get the access from someone who can grant. Or get it freed from them. icon_wink.gif
Back to top
View user's profile Send private message
dsivtina

New User


Joined: 05 Feb 2008
Posts: 5
Location: chennai

PostPosted: Thu Jul 16, 2009 2:33 pm    Post subject: Reply to: How to Free Bind Plan's created by others?
Reply with quote

It can't be done, since that User id is revoked.
Back to top
View user's profile Send private message
Gousiya Mulla

New User


Joined: 02 Jun 2008
Posts: 87
Location: Bangalore

PostPosted: Thu Jul 16, 2009 3:31 pm    Post subject:
Reply with quote

Try contacting your DB Support guys!


Cheers ..
Back to top
View user's profile Send private message
nagesh54

New User


Joined: 20 Jun 2008
Posts: 30
Location: Hyderabad

PostPosted: Fri Jul 17, 2009 9:54 am    Post subject: Reply to: How to Free Bind Plan's created by others?
Reply with quote

Hi,

DBA will have access to free the plans . Please contact your DBA for this.


Thanks and Regards,
Nagesh.
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Tue Jul 28, 2009 11:02 pm    Post subject:
Reply with quote

dsivtina,

Goto DB2I panel ->option 5
You will find all the options like BIND PLAN, REBIND PLAN, FREE PLAN etc.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jul 29, 2009 11:50 am    Post subject:
Reply with quote

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

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jul 29, 2009 11:58 am    Post subject:
Reply with quote

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
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 Free FILE not working for specific users sankalp-goyal CLIST & REXX 12 Mon Apr 25, 2016 6:33 pm
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts DB2 plan for DSNTEP2 / DSNTEP4 Mainak_Dalal DB2 3 Thu Jan 21, 2016 1:08 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us