Hi All,
I am working in db2 dpf environment where we have 3 BCU's connected to each other via rsh and /db2home is mounted on 2 machines.
I have 16 partitions which have there own db cfg and log files.
Q1.now i have script written in perl which shows me which all are the tablespaces and what how is free and used space .now i kept that script in the ihome/sqllib/bin (that is mounted all of 3 machines ) now when i call this script it doesnt work ..
or
other way to list tablespaces will db2_all " db2 connect to sample; db2 list tablespaces show detail ; db2 connect reset " ;
or
export db2node=x
db2 list tablespaces
db2 terminate


is there any other way i can do the same and see how many tablespaces are there in my tablespace ?

now db2_all is also kept in the same path as i kept my script so it should also work in the same manner ? am i wrong if i am please tell me why ?

can somebody gimme few scripts for DPF environment as all my scripts were only for non dpf environment ...
I am using db2 v 9.1.4a

What does "doesn't work" mean for you?

Please read this as well and act upon it: Must Read before posting