Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    72

    Unanswered: Db2 Dpf Environment

    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

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What does "doesn't work" mean for you?

    Please read this as well and act upon it: http://www.dbforums.com/showthread.php?t=854783
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •