RE: How to change the Database name on the AS400

I don't think there is any downside to the WRKRDBDIRE and deleting *LOCAL
entry and recreating a new one.  I recall doing this even on a production
machine.  Might be some SQL package objects from ODBC/JDBC that might use it
but those can be deleted and will re-create automatically.

Pete Helgren
Value Added Software, Inc
801.581.1154 x202

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Mike.Crump@xxxxxxxxxxxxxxxx
Sent: Wednesday, January 19, 2005 9:01 PM
To: Midrange Systems Technical Discussion
Subject: Re: How to change the Database name on the AS400


I will plead some ignorance here but I'm assuming that is coming from the
RDBE.  If you do a WRKRDBDIRE you will most likely see the name you are
referencing with a remote location of *LOCAL.  You will have to delete and
then add it back.  I've not done this so I'm not sure if there is anything
else you should look out for.  But if you aren't running production it
shouldn't be an issue.


Michael Crump
Manager, Computing Services
Saint-Gobain Containers
1509 S. Macedonia Ave.
Muncie, IN  47302
(765)741-7696
(765)741-7012 f
(800)428-8642

"The probability that we may fail in the struggle ought not to deter us from
the support of a cause we believe to be just"  Abraham Lincoln






                                                                           
             Ash G                                                         
             <njas400pgmr@yaho                                             
             o.com>                                                     To 
                                       midrange-l@xxxxxxxxxxxx             
             01/19/2005 10:46                                           cc 
             PM                                                            
                                                                   Subject 
                                       How to change the Database name on  
             Please respond to         the AS400                           
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           



All:

I am using a previously owned AS400. I was able to change the system name by
using the CHGNETA command.
Question: How do I change the database name of the system? When I use SQL it
says that the connection is to database [oldsysname]. I want this to have
the same name as [mysysname].
I can also see [oldsysname] value for the database name when I view the
AS400 through windows operations navigator?

TIA,
Ash.


---------------------------------
Do you Yahoo!?
 Yahoo! Search presents - Jib Jab's 'Second Term'
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.