Db2 DB21019E backup script error

Question

I am trying to run a backup script to backup database Sample

 su -c "${DB2Home}/db2 quiesce database immediate force connections" ${InstanceName} 

    echo "[INFO:`date`]Executing the backup command: ${DB2Home}/db2 backup database ${Primary_Server_DBName} to ${BackupFolder} compress without prompting "

   su -c "${DB2Home}/db2 backup database ${Primary_Server_DBName} to ${BackupFolder} compress without prompting" ${InstanceName}

I executed the script as a root user not as db2inst1 user

I am getting the following error

    [INFO:Tue Oct 21 18:44:23 IST 2014]Executing the backup command: /opt/ibm/db2/V10.5/bin/db2 backup database TIPDB to /home/db2inst1/backupFolder compress without prompting 
  DB21019E  An error occurred while accessing the directory 
    "/root".

A simple answer is: *do not* execute DB2 commands as `root`. — mustaccio, Oct 21 '14 at 14:02
I am running the script as a root user iam switching to db2inst1 user internally using su -c . By the way why did you downvote ? — user_D_A__, Oct 21 '14 at 14:43
http://stackoverflow.com/questions/710110/how-can-i-su-from-root-to-db2inst1-and-invoke-a-sql-script-in-one-line please refer to this link — user_D_A__, Oct 21 '14 at 14:52

score 2 · Accepted Answer · answered Oct 21 '14 at 14:21

2

The solution is to add . /home/db2inst1/sqllib/db2profile

before the db2 operations

answered Oct 21 '14 at 14:21

user_D_A__

460
2
6
14

Why would you run multiple `su` commands, as opposed to just putting all of the necessary commands in a shell script and executing that shell script via `su` ? – Ian Bjorhovde Oct 21 '14 at 16:25
This is just an example. I have only two commands. I dont require a script for it. – user_D_A__ Oct 21 '14 at 17:31

score -1 · Answer 2 · edited Mar 05 '21 at 16:37

-1

Before running the script use:

su - db2inst1

then run the script as usual:

db2 -stvf /yourpath/createDatabase1.sql

edited Mar 05 '21 at 16:37

Tomerikoo

18,379
16
47
61

answered Mar 05 '21 at 16:27

Harkconnen

1

Db2 DB21019E backup script error

2 Answers2