db2 prune history in DPF

dragon

Newcomer
Joined
Jan 6, 2012
Messages
3
Reaction score
0
Points
0
PREDATAR Control23

Hi all,

I have the problem when I have tried to execute next command in my DPF DB2 environment(v9.7 13 partitions):

db2inst1@suse1:/data/backups> db2_all "<<+12< db2 prune history 2018 WITH FORCE OPTION AND DELETE"
warning: no inet socket available: No such file or directory

SQL1024N A database connection does not exist. SQLSTATE=00000
suse4: db2 prune history ... completed rc=4


I have executed this command from the first host (where catalog partition exists).

Thanks
D.
 
PREDATAR Control23

Thanks Mita201,

I didn't paste all code. Of course I have made the connection first to catalog partition:

db2inst1@suse1:/data/backups> db2 connect to test

Database Connection Information

Database server = DB2/LINUXX8664 9.7.2
SQL authorization ID = DB2INST1
Local database alias = TEST

db2inst1@suse1:/data/backups> db2_all "<<+12< db2 prune history 2018 WITH FORCE OPTION AND DELETE"
warning: no inet socket available: No such file or directory

SQL1024N A database connection does not exist. SQLSTATE=00000
suse4: db2 prune history ... completed rc=4


I have also tried next command and it's successfully executed:

db2inst1@suse1:/data/backups> db2_all "<<+12< db2 get db cfg for TEST | grep -i First"
warning: no inet socket available: No such file or directory

First active log file = S0000004.LOG
First log archive method (LOGARCHMETH1) = DISK:/data/archive/
suse4: db2 get db cfg for ... completed ok


Is there something specific for DPF environment when executing db2 prune history command.

Thanks
D.
 
Last edited:
Top