Difference between db2_all "<<+0< and db2_all "<<-0<|| ?

[Former Member]

Hi!

I see 2 commands as follows:

db2_all "<<+0< db2 backup db foo"

db2_all "<<-0<|| db2 backup db foo"

What is the exact difference between the 2?

Thanks!

[Former Member · Accepted solution]

Hi,

In the first command, the db2_all utility will issue the backup command only on the first database partition.

In the second command, the db2_all utility will issue the same backup command to each database partition in turn (except database partition 0).

Best regards,

Joachim Müller

[Former Member · Accepted solution]

Mr.Muller:

What is the command to do all of partitions together?

Thanks!!

[Former Member · Accepted solution]

Hi,

see sample below

Prune history:

db2_all "||" echo DB_PART=##;db2 "call sysproc.admin_cmd('prune history 20070430')""

Best regards,

Joachim Müller