MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

DB2 Admin Tools - How to retain override of default settings

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
bstillwa
Beginner


Joined: 01 Nov 2004
Posts: 23
Topics: 6
Location: NJ

PostPosted: Fri May 25, 2007 1:10 pm    Post subject: DB2 Admin Tools - How to retain override of default settings Reply with quote

We have version 7.1.0 of DB2 Admin Tools. Under P - Change DB2 Admin parameters, 2 - Change DB2 Admin defaults, you can change some defaults. I change the "Max No of Rows to Fetch" to zero, and also change the "Reset to Def. at Startup" to NO. But at some point this keeps resetting back to 1000 and YES. Is there some secret to retaining this setting for a given ISPF user? The Users Guide states that when this "Reset to Def" is set to NO, "DB2 Admin attempts to restore the CURRENT SQLID." Can I have some explanation on this please, and why are these settings getting reset? Is this somehow tied to a TSO Userid? Could my shop perhaps have something in place to prevent users from overriding these defaults (I would ask them, but they probably either won't answer, or don't know). Where would I look to see how this is set up (if as a non-DBA, I am permitted to look)?
_________________
Bev.
Back to top
View user's profile Send private message
bstillwa
Beginner


Joined: 01 Nov 2004
Posts: 23
Topics: 6
Location: NJ

PostPosted: Wed May 30, 2007 8:28 am    Post subject: Reply with quote

I'll answer my own question. This setting is not getting reset. I believe what was happening is that I was being timed-out of TSO before cleanly exiting from DB2TOOLS. The option settings are now staying set the way I want them. Embarassed
_________________
Bev.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group