question about database layout
Posted in 1997
Topics: Storage & Space Management, Server Administration
I am a new boy to this group and fairly new to dba work as a whole. Basically, I have been given dba responsibility for 4 large databases. I am trying to get to grips with the main duties of a dba but to start with I thought it might be useful to understand how the database is designed, in terms of dbspaces, databases within each dbspace, how the databases relate to chunks, what tables exist in each database and from that what tables are in a chunk. I plan to draw up an entity relationship diagram defining how all the various tables are linked, in terms of columns existing in one table and also in another. Also I wanted to see the dependencies that exist so that I could know that by dropping a table whether it would affect a series of other tables. Is there a known way I should go about finding out this information, ie. particular tools or sql statements that I should be using? Thanks in advance Paul Matthews begin 600 WINMAIL.DAT M>)\\^(A,,`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <` M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0F `0`A````-#@X03-" M1D)$-3(U1#$Q,3DV-C0P,# T04,V-#4R,D,```<!(( #``X```#-!PD`!0`% M`#4`$0`%`#(!`06 `P`.````S0<)``4`!0`P`!\\`!0`[`0$-@ 0``@````(` M`@`!!( !`!\\```!Q=65S=&EO;B!A8F]U="!D871A8F%S92!L87EO=70`Q@L! M`Y &`- %```7````0 `Y`* L[P/ZN;P!'@!P``$````@````('%U97-T:6]N M(&%B;W5T(&1A=&%B87-E(&QA>6]U= `"`7$``0```" ````!O+GKOFW[.XI! M)=41T99D``2L9%(L``+ YG$``+_,$0,`!A!\\3-WM`P`'$.<"```>``@0`0`` M`&4```!)04U!3D570D]95$]42$E31U)/55!!3D1&04E23%E.15=43T1"05=/ M4DM!4T%72$],14)!4TE#04Q,62Q)2$%614)%14Y'259%3D1"05)%4U!/3E-) M0DE,25191D]2-$Q!4D=%``````,`$! ``````P`1$ `````"`0D0`0```&T# M``!I`P``9@4``$Q:1G6W@#-D_P`*`0\\"%0*H!>L"@P!0`O()`@!C: K <V5T M,C<&``;#`H,R`\\4"`'!R0G$1XG-T96T"@S.W`N0'$P*#- /&%,@U$LSM%,@V M`\\8/W7T*@ C/"=GR.QIR,C46D!K?":L;X4\\"@ J!#;$+8&YG`= U7C<*^Q5B M# $34&\\3T&/#!4 *BVQI,S8@41^O(2"R22!A;2.0(&Y#!]$&X'D@=&\\D8&@M M! `@"< (8' CD&YDY"!F"W!R;"10(_(D<=1D8B/0=P6P:R.0!""E)I%H!O!E M+@J%0B<`;&EC!T ET"PC<1& =NYE)" )X23@:2D0`Z F<ED:@'-P`B `D&(# M$&E.="10`A %P#0@"V!R\\F<I(&1A`9$G``>0)Z;1(X-T<GD+@&<D8BNP_P5 M+;(%$00@`_ DH"21*2!G`, +@"9@=70(D 0@;_9F(\\$F<F(OH"1B$\\ *P)\\% M0"ZS(X DH A@9V@%0)LJX"\\P:3(2*4 @=1&P[&9U`R D<74E8 20,0'_)6$G M8"8A+Q$KYC) !" -L'4`D&<C\\&0HL"]A$]!R_FTOXR9P*E `T >0*+ KY_LN MHR]A90#0+N W!2BP-&Y_!" :@ M@$] D8A%P,[!K?S=Q)U K\\"1@`: G@ 0@ M9?YX! `R,3B6-/8E4P-A))'_._$[V@K -5$#H"/0.U,L>.<+4391)E%R80?@ M)2,XH'<","KB.K-I*G$DL"4P9/\\', G (Z$-L0N +7(T8BAQ_2[S=@K 0Q S M$#\\J(< [@/,V#AGQ=6T&,3R3+7(O8=\\"(#L!/#(E0P= <R2 /^+F;B"0+Q!R M+A2P2@(C@'YW`' 3T"5P,-()X#249>9P"? -L&YC+\\(^DSR4OTH1/I,C@ 6@ M,U E<&M*@!\\T@COQ)" D4$&@;W!P_RUR(]!)5"=0$<!*L3)")K#]3M)A#= @ MLB/0$; (@2_C]TJ3/!5*X$E-0@20/>%/`[\\#H$MP)% C@$- 3L-G)(#_`: ( M8 5 1#%#D"V!5E(DH_\\+@"LA`,!#`C8A)Y!!$#$A?RA0,U *P21P!O OX07 M<_YQ`R Q`1/10E%-155W,N/M+7$_(.8*A501@#N!/].69$5@30!E7&Q083-1 MYDTK\\"\\!=W-<; K[%%$7(#\\%P!FA`&-0`````P`V```````#`"8```````(! M^3\\!````'@````````#<IT#(P$(0&K2Y" `K+^&"`0`````````N````'@#X M/P$````5````4WES=&5M($%D;6EN:7-T<F%T;W(``````@'[/P$````>```` M`````-RG0,C 0A :M+D(`"LOX8(!`````````"X````>`/H_`0```!4```!3 M>7-T96T@061M:6YI<W1R871O<@````! ``<P8'PVP?FYO % ``@P\\ U:KOJY MO $#``TT_3\\```(!%#0!````$ ```%24H< I?Q ;I8<(`"LJ)1<>`#T``0`` M``$`````````"P`I```````+`",```````(!?P`!````/0```#QC/4=")6$] M7R5P/59I<V$E;#U625-!+T550T5-14$O,# P13(Y-S9 ;7-M86EL9W<R+G9I -<V$N8V]M/@`````;N%-! ` end