Documentation Center

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 fileNotes If a switch is not specified, the default password in the XyConfig.bin file is applied
dbcopy.plyesyesSpecify the (database) password for the existing database—that is,the database being copied.The password is applied to the new, copied database.
dbexport.plyesyesSpecify the (database) password for the database being exported.
dbimport.plyesyesSpecify 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.plyesyesSpecify the (database) password for the database being dropped.
dbstatyesSpecify the sysadmin password if it is not the default password inthe XyConfig.bin file.
listdb.plyesSpecify the sysadmin password ifit is not the default password in theXyConfig.binfile.
newdb.plyesyesSpecify 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.plyesyesSpecify the (database) password for the database you want to compute stats.
pcm_update_indexes.plyesyesSpecify the (database) password for the database you want to update indexes.