V
vithal.kattikar@hgst.com
Guest
Thanks James , I assume that step 1 and step 2 are correct . In step 3 , insted of performing in dump and load , it is good to perform binary dump and load.Please correct me if I understood something wrong. Yes cverbiest's suggested to load other stuffs also individually , one question here if I perform binary dump and load , is it necessary to load other stuffs like users defination , sequence current values , sql permision , sql views seperately . second thing is like how do I know binary dump and load is successfull. Below is my program for performing binary dump and load. define var vdb as char format "X(10)" no-undo. update vdb. output to value("dump" + vdb + ".sh"). for each _file no-lock: put unformatted "proutil " + vdb + " -C dump " + _file-name + " /u2/tsmpdump/ " skip. end. output close. output to value("load" + vdb + ".sh"). put unformatted "proutil " + vdb + " -C truncate bi -G 0 -biblocksize 32 -bi 65536" skip "proserve " + vdb + " -B 20000 -spin 20000 -bibufs 300" skip "probiw " + vdb skip "proapw " + vdb skip "proapw " + vdb skip. for each _file no-lock: put unformatted "proutil " + vdb + " -C load /u2/tsmpdump/" + _file-name + ".bd " skip. end. put unformatted "proshut " + vdb + " -by" skip "proutil " + vdb + " -C idxbuild all -TB 32 -TM 32" skip "proutil " + vdb + " -C truncate bi -G 0 -biblocksize 16 -bi 32768" skip. output close.
Continue reading...
Continue reading...