################################################################ 1) Recreer une nouvelle "master" ################################################################ # Size = 64Mb = 32768 blocks of 2K (36*512) # buildmaster -d/dev/rdsk/c0t0d0s6 -s66144K ################################################################ 2) Ajouter les "devices" ################################################################ isql -Usa -P /************ These are required for a recration **************/ /* Creation of System Devices */ # disk init name="sysprocsdev", physname = "/dev/rdsk/c1t0d0s7", # vdevno = 1, size = 63488 /* 124Mbytes */ # go disk init name="sylog", physname = "/dev/rdsk/c1t0d0s5", vdevno = 2, size = 4965888 /* 9699Mbytes */ go ################################################################ 3) Executer les Scripts ################################################################ cd $SYBASE/scripts || echo "****PROBLEM $SYBASE/scripts" isql -Usa -P < installmaster isql -Usa -P < installmodel ################################################################ 4) Remove DISK + Recreate ... ################################################################ #rm /usr?/sybase/+syb? #rm /nbk/fs1/sybase/+syn1? isql -Usa -P << ====Init sp_password NULL, archiciel go /*------------- Rest after all recreations -------------*/ alter database tempdb on sylog = 128 go /* Creation of Devices (limit = 1,000,000 blocks!!) */ disk init name="v03c1t1", physname = "/dev/rdsk/c1t1d0s5", vdevno = 3, size = 4108288 /* 8024 Mbytes */ go disk init name="v04c1t1", physname = "/dev/rdsk/c1t1d0s6", vdevno = 4, size = 4108288 /* 8024 Mbytes */ go disk init name="v05c7t2", physname = "/dev/rdsk/c7t2d0s5", vdevno = 5, size = 4423680 /* 8640 Mbytes */ go disk init name="v06c7t4", physname = "/dev/rdsk/c7t4d0s5", vdevno = 6, size = 4423680 /* 8640 Mbytes */ go disk init name="v07c8t10", physname = "/dev/rdsk/c8t10d0s6", vdevno = 7, size = 4423680 /* 8640 Mbytes */ go /* Adding DLT Device */ sp_addumpdevice "tape", "DLT", "/dev/nrst43", 25000 go /*==================================================================== Mirroring *====================================================================*/ disk mirror name = "master", mirror="/home/sybase/data/master.dat" go disk mirror name = "v03c1t1", mirror="/r/5/sybase/v03.dat" go disk mirror name = "v04c1t1", mirror="/r/5/sybase/v04.dat" go disk mirror name = "v05c7t2", mirror="/var/sybase/v05.dat" go disk mirror name = "v06c7t4", mirror="/home/sybase/data/vizmain.dat" go disk mirror name = "v07c8t10", mirror="/var/sybase/v07.dat" go /*==================================================================== Adding the LOGIN *====================================================================*/ sp_addlogin "francois", "archifox", NULL, NULL, "Francois" go sp_adduser francois go sp_addlogin "pipecat", "esis95", NULL, NULL , "Pipeline" go sp_addlogin "cloner", "asu4Clone", NULL, NULL , "For metatemp" go sp_addlogin "bonnarel", "alaciel", NULL, NULL , "Francois" go sp_addlogin "ddurand", "2Change", NULL, NULL , "Daniel" go sp_addlogin "alamgr", "alaciel", NULL, NULL , "Aladin" go sp_addlogin "asu", "asu4VizieR", NULL, NULL , "Astronomical" go /* === Change the MODEL data-base === */ use model go sp_addgroup aladin go sp_addgroup cats go sp_addgroup simbad go sp_adduser francois go sp_adduser guest go sp_adduser asu go sp_addgroup archives go sp_helpgroup go sp_helpuser go use master go sp_dboption model, "select into/bulkcopy", true go sp_dboption model, trunc,true go sp_dboption model, "abort tran on log full", true go use model go checkpoint go ====Init ######################################################################## #### Create Data-bases ######################################################################## => ima.cre => archives.cre => dea/dea.cre => Creation de VizieR: cd meta metacre metakoh -go -f catkeys -u units metaspec -all vizier.cre ######################################################################## #### Change default data-bases ######################################################################## isql -Usa -Parchiciel << ===Defaults sp_modifylogin francois, defdb, archives go sp_modifylogin pipecat, defdb, metaviz go sp_modifylogin bonnarel, defdb, ima go sp_modifylogin ddurand, defdb, archives go sp_modifylogin alamgr, defdb, ima go sp_modifylogin dea, defdb, dea go sp_modifylogin asu, defdb, metaviz go ===Defaults