What am i doing wrong

According to documentation $N will be replaced by nodenumber
But i have no luck. Any ideas

db2_all "<<+0< db2 -v "backup db dqa07crd to /db2fs1p $N/backups/dqa07crd compress without prompting""

Any ideas !!!!

Your use of quotes seems strange. And if you use $N like you do, your shell interprets that as a variable and expands it before DB2 sees the $N at all. How about this:
With the use of single quotes, you prevent the interpretation of the shell.

This is a DPF question for those who don't know.

I have used that syntax successfully in a create tablespace SQL statement, but I did not know it can be used in a DB2 command. Let us know if you get it working.

Sorry guys even with the single quote it is not working. When evaluated it is evaluated as space

==> db2_all '<<+0< db2 -v "backup db dqa07crd to /db2fs1p $N/backups/dqa07crd compress without prompting"'

backup db dqa07crd to /db2fs1p /backups/dqa07crd compress without prompting
SQL0104N An unexpected token "/backups/dqa07crd" was found following
"<identifier>". Expected tokens may include: "INCLUDE". SQLSTATE=42601

ga016d08b: db2 -v "backup db ... completed rc=4

Are you sure about that? As far as I know, ## is substituted with the partition number in the context of rah or db2_all.

=> db2_all 'echo $DB2NODE'

1
srvr01: echo $DB2NODE completed ok

2
srvr01: echo $DB2NODE completed ok

3
srvr01: echo $DB2NODE completed ok

4
srvr01: echo $DB2NODE completed ok

5
srvr01: echo $DB2NODE completed ok

6
srvr01: echo $DB2NODE completed ok

7
srvr01: echo $DB2NODE completed ok

8
srvr01: echo $DB2NODE completed ok

9
srvr01: echo $DB2NODE completed ok

10
srvr01: echo $DB2NODE completed ok

11
srvr01: echo $DB2NODE completed ok

12
srvr01: echo $DB2NODE completed ok


As for rah, it has nothing to do with partition number, but rather server addresses in sqllib/db2nodes.cfg

I think I've only seen " $N" used with create tablespace or set tablespace containers... but you may try the following:

use escape character in front of "$" and single quotes around the path. Something like this:

..... '/db2fs1p \$N/backups/dqa07crd' ....


I can't get db2_all to work at this time so can't test this myself.

db2_all is not working for me so I used SSV backup method instead just to see if I can use " $N" in the path.

Here are my results:

test@p6db2serv /home/test/BACKUP > db2 "backup db test on all dbpartitionnums to '/home/test/BACKUP/N \$N'"
Part Result
---- ------------------------------------------------------------------------
0000 DB20000I The BACKUP DATABASE command completed successfully.
0001 DB20000I The BACKUP DATABASE command completed successfully.
0002 DB20000I The BACKUP DATABASE command completed successfully.

Backup successful. The timestamp for this backup image is : 20091103081248


test@p6db2serv /home/test/BACKUP > ls -l *
N0:
total 148144
-rw------- 1 test build 75849728 Nov 03 08:12 TEST.0.test.NODE0000.CATN0000.20091103081248.001

N1:
total 35384
-rw------- 1 test build 18116608 Nov 03 08:12 TEST.0.test.NODE0001.CATN0000.20091103081248.001

N2:
total 35384
-rw------- 1 test build 18116608 Nov 03 08:12 TEST.0.test.NODE0002.CATN0000.20091103081248.001

Still no luck

==> db2_all '<<+0< db2 -v "backup db sample to '/db2fs1p \$N /backups/dqa07crd' compress without prompting"'

backup db sample to /db2fs1p /backups/dqa07crd compress without prompting
SQL0104N An unexpected token "/backups/dqa07crd" was found following
"<identifier>". Expected tokens may include: "INCLUDE". SQLSTATE=42601

ga016d08b: db2 -v "backup db ... completed rc=4

I ties this this too. Hoping atleast catalog node will be backedup

db2 "backup db sample to '/db2fs1p \$N/backups/dqa07crd'"
SQL2036N The path for the file or device "/db2fs1p $N/backups/dqa07crd" is
not valid.

Note the " prefix.

This seem to work after lots of permutations and combinations

db2_all "\"<<+0< db2 -v \"backup db sample to /db2fs1p##/backups/dqa07crd compress without prompting\""

It still does not make sense why i have to use the so many escape chars

Nick your combination worked too.
What i dont understand is you started two double quotes but ended only one

place N in brackets: ${N} , otherwise AIX thinks everything after N is a part of a variable name