Question & Answer
Question
How do I change the default case for a Netezza database or for the entire appliance?
Answer
Commencing with NPS 4.0, the default object case is uppercase. If for some reason, you need to convert to lowercase or vice versa, refer to the IBM Netezza System Administrator’s Guide which describes command line utilities nzconvertdbcase and nzconvertsyscase which will allow you to convert a single database or an entire system, respectively, to a different default case.
Note: As of NPS Release 4.6, the nzconvertdbcase command has been deprecated. The nzconvertsyscase command remains supported.
To run these command line utilities, do the following:
1. Log into the NPS host as the nz user.
2. Backup the NPS events by running the following:
/nz/kit/sbin/dbupgrade/nzBackupEvents > /tmp/restoreEvents.sh
3. Stop the database by running the following:
nzstop
4. Run either nzconvertdbcase or nzconvertsyscase with the appropriate arguments. Specifying the -h argument will describe the command line options which need to be passed.
5. Start the database by running the following:
nzstart
6. Restore the original defined NPS events by running the following commands:
chmod +x /tmp/restoreEvents.sh
/tmp/restoreEvents.sh
Historical Number
NZ554069
Was this topic helpful?
Document Information
More support for:
IBM PureData System
Software version:
1.0.0
Document number:
460955
Modified date:
17 October 2019
UID
swg21568547