Database stratigies ? ? ?

Item Subject: Re: Renaming data bases
     Any insight into the better of JFS database space and raw volume
     database space... seems when I expanded my DB and went to raw volumes
     I've introduced something that hangs the backups nightly.... tonight
     will make the second night that NO BACKUPS will complete...
     If anyone would like to glance at my env, here is some general poop...
     I'm going to talk to some ISSC guys tomorrow but... argh !
     later
          Dwight
Script started on Tue Jun 25 20:44:08 1996
root> lsvg

rootvg

dsmdbvg

dsm103vg

dsm104vg

dsm105vg

dsm106vg

tdcdsmvg1

tdcdsmvg2

tdcdsmvg3

tdcdsmvg4

tdcdsmvg5

tdcdsmvg6

root> lsvg -p dsmdbvg

dsmdbvg:

PV_NAME           PV STATE    TOTAL PPs   FREE PPs    FREE DISTRIBUTION

hdisk7            active      268         0           00..00..00..00..00

hdisk31           active      268         0           00..00..00..00..00

hdisk41           active      268         0           00..00..00..00..00

hdisk54           active      268         0           00..00..00..00..00

hdisk22           active      268         0           00..00..00..00..00

hdisk14           active      268         0           00..00..00..00..00

root> lspv -p hdisk7

hdisk7:

PP RANGE  STATE   REGION        LV NAME             TYPE       MOUNT POINT

  1-54    used    outer edge    dsmdb02b            raw        N/A

 55-108   used    outer middle  dsmdb02b            raw        N/A

109-146   used    center        dsmlog01b           raw        N/A

147-161   used    center        dsmdb01b            raw        N/A

162-214   used    inner middle  dsmdb01b            raw        N/A

215-268   used    inner edge    dsmdb01b            raw        N/A

root> lspv -p hdisk31

hdisk31:

PP RANGE  STATE   REGION        LV NAME             TYPE       MOUNT POINT

  1-54    used    outer edge    dsmdb04b            raw        N/A

 55-108   used    outer middle  dsmdb04b            raw        N/A

109-146   used    center        dsmlog02b           raw        N/A

147-161   used    center        dsmdb03b            raw        N/A

162-214   used    inner middle  dsmdb03b            raw        N/A

215-268   used    inner edge    dsmdb03b            raw        N/A

root> lspv -p hdisk41

hdisk41:

PP RANGE  STATE   REGION        LV NAME             TYPE       MOUNT POINT



  1-54    used    outer edge    dsmdb02a            raw        N/A

 55-108   used    outer middle  dsmdb02a            raw        N/A

109-146   used    center        dsmlog01a           raw        N/A

147-161   used    center        dsmdb01a            raw        N/A

162-214   used    inner middle  dsmdb01a            raw        N/A

215-268   used    inner edge    dsmdb01a            raw        N/A

root> lspv -p hdisk54

hdisk54:

PP RANGE  STATE   REGION        LV NAME             TYPE       MOUNT POINT

  1-54    used    outer edge    dsmdb04a            raw        N/A

 55-108   used    outer middle  dsmdb04a            raw        N/A

109-146   used    center        dsmlog02a           raw        N/A

147-161   used    center        dsmdb03a            raw        N/A

162-214   used    inner middle  dsmdb03a            raw        N/A

215-268   used    inner edge    dsmdb03a            raw        N/A

root> lspv -p hdisk22

hdisk22:

PP RANGE  STATE   REGION        LV NAME             TYPE       MOUNT POINT

  1-54    used    outer edge    dsmdb06a            raw        N/A

 55-108   used    outer middle  dsmdb06a            raw        N/A

109-146   used    center        dsmlog03a           raw        N/A

147-161   used    center        dsmdb05a            raw        N/A

162-214   used    inner middle  dsmdb05a            raw        N/A

215-268   used    inner edge    dsmdb05a            raw        N/A

root> lspv -p hdisk14

hdisk14:

PP RANGE  STATE   REGION        LV NAME             TYPE       MOUNT POINT

  1-54    used    outer edge    dsmdb06b            raw        N/A

 55-108   used    outer middle  dsmdb06b            raw        N/A

109-146   used    center        dsmlog03b           raw        N/A

147-161   used    center        dsmdb05b            raw        N/A

162-214   used    inner middle  dsmdb05b            raw        N/A

215-268   used    inner edge    dsmdb05b            raw        N/A

root> dbio



tty:      tin         tout   avg-cpu:  % user    % sys     % idle    % iowait

          0.1          9.2              11.3     20.2       29.8      38.7



Disks:        % tm_act     Kbps      tps    Kb_read   Kb_wrtn

hdisk7          13.3       3.4      11.6    4079805   1053835

hdisk14          0.5       3.7       0.5    2438570   3142066

hdisk22          0.0       0.5       0.0       2328    681899

hdisk31         18.4       3.1      13.2    1844536   2778007

hdisk41          3.4       2.3       3.4    1877493   1536012

hdisk54         19.8       2.1      13.7    1563500   1623045

root>
script done on Tue Jun 25 20:46:28 1996