How To Rename Your Local Database
January 5, 2011 Hey, Ted
When I start up an interactive SQL session I see “Current connection is to relational database Sxxxxxxx.” Sxxxxxxx is our serial number. Is there a way to change the relational database name to something a little more meaningful?
Use the Work with Relational Database Directory Entry (WRKRDBDIRE) command. The entry you need to change is for remote location *LOCAL. For more information about WRKRDBDIRE, see Using the WRKRDBDIRE command at IBM‘s Info Center.
That solved the problem. It was little scary because I couldn’t change the name, but had to delete the existing one and recreate it. The second level text on the warning message let me know what to do, though.