About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
The detailed steps for creating a new backup user for PDA.
Answer
1. Log on as root on ha1 and add a new Linux user:
useradd databkp_usr
echo "databkp_usr<CTRL j>databkp_usr"| passwd databkp_usr
2. Ensure the user was created successfuly. This command:
grep databkp_usr /etc/passwd
should return something like:
databkp_usr:x:503:503::/home/databkp_usr:/bin/bash
3. Log on as root on ha2 and add another user there with the same name and UID:
ssh ha2
useradd databkp_usr
echo "databkp_usr<CTRL j>databkp_usr"| passwd databkp_usr
grep databkp_usr /etc/passwd
4. Create database group with backup and restore privileges, and user:
nzsql -c "Create Group BACKUP_USERS_GRP;"
nzsql -c "Grant Backup, Restore To BACKUP_USERS_GRP ;"
nzsql -c "Create User DATABKP_USR_DB With Password 'xxxxxxxx'
In Group BACKUP_USERS_GRP;"
5. Set environment variables in databkp_usr's .bashrc file on both ha1 and ha2
cd ~databkp_usr
cp ~nz/.bashrc .
vi ./.bashrc
Add or change these lines:
# For NPS
export NZ_USER=databkp_usr_db # Default NZ username#
export NZ_PASSWORD=xxxxxxxx # Default NZ password
export NZ_DATABASE=system # Default NZ database
export NZ_HOST=$(hostname)
6. Login as databkp_usr and take a backup on both ha1 and ha2 to confirm it all works:
nzbackup -db sample_db -dir /tmp -v
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
More support for:
IBM PureData System
Software version:
1.0.0
Document number:
521221
Modified date:
17 October 2019
UID
swg21692073