Password switch information for Perl database utilities
This topic describes password switches for Perl database utilities.
If the password switch is necessary, the switch column in the table indicates yes. If the switch is not necessary or is not a valid switch for the utility, the column contains an em dash (—).
Information about using a switch is noted in the column heading for the switch.
Information about providing the database password (-pdmpwd) is noted in the Notes column.
| Utility | -xyadminpwd Use if the sysadmin user’s password is not the default password in the XyConfig.bin file | -pdmpwd Use if the database’s password is not the default password in the XyConfig.bin file | Notes If a switch is not specified, the default password in the XyConfig.bin file is applied |
|---|---|---|---|
| dbcopy.pl | yes | yes | Specify the (database) password for the existing database—that is,the database being copied.The password is applied to the new, copied database. |
| dbexport.pl | yes | yes | Specify the (database) password for the database being exported. |
| dbimport.pl | yes | yes | Specify the (database) password you want applied to the database being imported.When specifying a new database password, the password can be added to the XyConfig.bin file before or after importing the database—see Create Password Procedure. To change the database password subsequent to import, see Modify Password Procedure. |
| dropdb.pl | yes | yes | Specify the (database) password for the database being dropped. |
| dbstat | yes | Specify the sysadmin password if it is not the default password inthe XyConfig.bin file. | |
| listdb.pl | yes | Specify the sysadmin password ifit is not the default password in theXyConfig.binfile. | |
| newdb.pl | yes | yes | Specify the (database) password you want applied to the new database.When specifying a database password, add the password to the XyConfig.bin file before creating the database—see Create Password Procedure. To change the database password subsequent to import, see Modify Password Procedure. |
| pcm_compute_stats.pl | yes | yes | Specify the (database) password for the database you want to compute stats. |
| pcm_update_indexes.pl | yes | yes | Specify the (database) password for the database you want to update indexes. |