Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Changing the Database which appears as the system name serial number.
208 views
Skip to first unread message
A. Perry Nelson
Oct 12, 2014, 9:58:40 PM10/12/14
to
Does anyone know how to change the database name in the iNavigator?, I just hate the serial number as db name. I have changed the system network name. thank yall P
Ad
Oct 13, 2014, 2:11:34 PM10/13/14
to
WRKRDBDIRE
delete the old name
add new *lOCAL Database
delete the old name
add new *lOCAL Database
A. Perry Nelson
Oct 14, 2014, 12:00:51 AM10/14/14
to
On Sunday, October 12, 2014 9:58:40 PM UTC-4, A. Perry Nelson wrote:
> Does anyone know how to change the database name in the iNavigator?, I just hate the serial number as db name. I have changed the system network name. thank yall P
Thanks a bunch!
> Does anyone know how to change the database name in the iNavigator?, I just hate the serial number as db name. I have changed the system network name. thank yall P
centu...@gmail.com
Mar 25, 2015, 3:28:25 PM3/25/15
to
I have a related question.
When trying to delete the RDB, I get this warning message:
"Removing the *LOCAL directory entry may cause loss of configuration data."
I was wondering, what configurations could be lost and what kind of trouble could be caused if I delete and recreate this entry (besides the fact that the pre-existing references to the former RDB name would not be valid anymore)
Thank you!
When trying to delete the RDB, I get this warning message:
"Removing the *LOCAL directory entry may cause loss of configuration data."
I was wondering, what configurations could be lost and what kind of trouble could be caused if I delete and recreate this entry (besides the fact that the pre-existing references to the former RDB name would not be valid anymore)
Thank you!
CRPence
Mar 26, 2015, 8:54:32 AM3/26/15
to
On 25-Mar-2015 14:28 -0500, centu...@gmail.com wrote:
> <<SNIP>>
(RMVRDBDIRE) of the RDB() name that defines [instead of a Remote
Database, defines] the database of the local system['s *SYSBAS].
> "Removing the *LOCAL directory entry may cause loss of configuration
> data."
Specifically, that is the inquiry msg CPA3E01 "Removing the *LOCAL
directory entry may cause loss of configuration data. (C G)".
> I was wondering, what configurations could be lost and what kind of
> trouble could be caused if I delete and recreate this entry (besides
> the fact that the pre-existing references to the former RDB name
> would not be valid anymore)
The message details, available from F1=Help with the cursor
positioned on the first-level text of the message, describes what is
lost and that the recovery is with use of the Change DDM TCP/IP
Attributes (CHGDDMTCPA) command to record the existing values and then
to reset them, if the option G=Go is the choice instead of C=Cancel:
From output of DSPMSGD CPA3E01:
" Cause . . . . . : An attempt was made to remove the *LOCAL RDB
directory entry, or to change it to a type of other than *LOCAL. This
entry is used to store configuration data for the CHGDDMTCPA command.
If the *LOCAL entry is removed, configuration data may be lost, and the
default configuration values will be in effect. If the default values
are not satisfactory, configuration data will have to be re-entered with
the CHGDDMTCPA command.
Recovery . . . : If there is no need to delete the *LOCAL entry,
or to change it to a remote entry, enter C to cancel processing. If the
*LOCAL entry must to be deleted so that the RDB name associated with it
can be changed, you may want to first record the values displayed by the
CHGDDMTCPA command so that they can be restored after the *LOCAL entry
is gone. You may also want to record those values, if the *LOCAL entry
is being deleted, as part of a generic or group delete. Enter G only if
you want to proceed to remove the *LOCAL entry now."
The CHGDDMTCPA enables establishing configuration settings for both
the Autostart Server (AUTOSTART) and Password Required (PWDRQD)
parameters. As I recall, only the latter of those is stored with the
data representing the *LOCAL RDBDIRE [as either the value of the
Security Mechanism (DBXRSEC) column or the (DBTFLGS) column] of the
database file QADBXRDBD in QSYS, in the row WHERE DBXRMTN='*LOCAL'. The
AutoStart should be stored as part of data for the *DDM server row in
the file QATOCSTART in QUSRSYS.
--
Regards, Chuck
> <<SNIP>>
> When trying to delete the RDB, I get this warning message:
In effect, a request to Remove Relational DataBase Directory Entry
(RMVRDBDIRE) of the RDB() name that defines [instead of a Remote
Database, defines] the database of the local system['s *SYSBAS].
> "Removing the *LOCAL directory entry may cause loss of configuration
> data."
directory entry may cause loss of configuration data. (C G)".
> I was wondering, what configurations could be lost and what kind of
> trouble could be caused if I delete and recreate this entry (besides
> the fact that the pre-existing references to the former RDB name
> would not be valid anymore)
positioned on the first-level text of the message, describes what is
lost and that the recovery is with use of the Change DDM TCP/IP
Attributes (CHGDDMTCPA) command to record the existing values and then
to reset them, if the option G=Go is the choice instead of C=Cancel:
From output of DSPMSGD CPA3E01:
" Cause . . . . . : An attempt was made to remove the *LOCAL RDB
directory entry, or to change it to a type of other than *LOCAL. This
entry is used to store configuration data for the CHGDDMTCPA command.
If the *LOCAL entry is removed, configuration data may be lost, and the
default configuration values will be in effect. If the default values
are not satisfactory, configuration data will have to be re-entered with
the CHGDDMTCPA command.
Recovery . . . : If there is no need to delete the *LOCAL entry,
or to change it to a remote entry, enter C to cancel processing. If the
*LOCAL entry must to be deleted so that the RDB name associated with it
can be changed, you may want to first record the values displayed by the
CHGDDMTCPA command so that they can be restored after the *LOCAL entry
is gone. You may also want to record those values, if the *LOCAL entry
is being deleted, as part of a generic or group delete. Enter G only if
you want to proceed to remove the *LOCAL entry now."
The CHGDDMTCPA enables establishing configuration settings for both
the Autostart Server (AUTOSTART) and Password Required (PWDRQD)
parameters. As I recall, only the latter of those is stored with the
data representing the *LOCAL RDBDIRE [as either the value of the
Security Mechanism (DBXRSEC) column or the (DBTFLGS) column] of the
database file QADBXRDBD in QSYS, in the row WHERE DBXRMTN='*LOCAL'. The
AutoStart should be stored as part of data for the *DDM server row in
the file QATOCSTART in QUSRSYS.
--
Regards, Chuck
A. Perry Nelson
Mar 26, 2015, 11:24:53 PM3/26/15
to
On Sunday, October 12, 2014 at 9:58:40 PM UTC-4, A. Perry Nelson wrote:
> Does anyone know how to change the database name in the iNavigator?, I just hate the serial number as db name. I have changed the system network name. thank yall P
If you delete the dba, wouldn't that mess with your relationships from the main table. Like deleting a physical file with logical, it will not let your delt the physical file. But really to bust some bubbles, table and view are nothing more than physical and logicals.
> Does anyone know how to change the database name in the iNavigator?, I just hate the serial number as db name. I have changed the system network name. thank yall P
0 new messages