<!-- Title: 09:01:58  Mon Dec 13 2004 -->
<!-- Crewchief: new day  -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Mon Dec 13 09:02:05 2004 -->
<pre>The Filecatalog user needs to allow: 
 
execute on filecatalog.oracle_to_unix_date & 
execute on filecatalog.unix_time & 
execute on filecatalog.get_chicago_tzone 
 
We could also,  as Alan recommends assign cdf_reader to samread, this 
will allow the samread user to read all tables, since the cdf_reader account 
is assigned select_any_table.  Right now samread does not have 
access to all tables. 
 
Dmitri  i.e. Filecatalog owner should do the execute above, 
and let us know if you want samread to be assigned cdf_reader.  
 
Thanks 
Nelly 
 
 
 
----- Original Message -----  
From: "Art Kreymer" &lt;kreymer@fnal.gov&gt; 
To: &lt;wicklund@fnal.gov&gt; 
Cc: &lt;cdfdb-support@fnal.gov&gt; 
Sent: Friday, December 10, 2004 2:02 PM 
Subject: Re: Request of the use of a different oracle account 
 
 
&gt; On Thu, 9 Dec 2004, Eric J. Wicklund wrote: 
&gt; ... 
&gt;&gt; Would you please change 
&gt;&gt; ~cdfsoft/dist/releases/development/bin/Linux2-GCC_3_3/iomap.txt 
&gt;&gt; to 
&gt;&gt; 
&gt;&gt; sam_catalog   OTL  samread/reader@cdfofprd 
&gt;&gt; 
&gt;&gt; instead ? 
&gt;  
&gt; I tried this, and got this from a AC++Dump : 
&gt;  
&gt; Error 1031 : ORA-01031: insufficient privileges 
&gt; ... 
&gt;  
&gt;  
&gt;  
&gt; I have created an sqlplus example demonstrating this : 
&gt;  
&gt; fcdflnx2 &gt; /cdf/home/kreymer/testsamdb cdf_reader 
&gt; ... 
&gt; ---------- ----------------- ---------- -------------- --------------- 
&gt; UPDATETIME CREATEDATE UPPER(SMV.VOLUME_NAME) 
&gt; ---------- ---------- -------------------------------------------------- 
&gt;  
&gt;  
&gt; Elapsed: 00:00:00.06 
&gt;  
&gt; # now with an incorrect account 
&gt;  
&gt; fcdflnx2 &gt; ./testsamdb samreader 
&gt; ERROR: 
&gt; ORA-01017: invalid username/password; logon denied 
&gt; ... 
&gt;  
&gt; # now with the samread account 
&gt;  
&gt; fcdflnx2 &gt; ./testsamdb samread 
&gt; DATASETNAME, Oracle_To_Unix_Date(SMDF.END_TIME) 
&gt;             * 
&gt; ERROR at line 9: 
&gt; ORA-01031: insufficient privileges 
&gt;  
&gt;  
&gt; Elapsed: 00:00:00.01 
&gt;</pre>
<!-- Author: nstanfield  -->
<!-- Comment: Mon Dec 13 09;03;14 comment by...ns  -->
<pre>The iomap.txt  change from user cdf_reader to samreader for sam_catalog
seems reasonable to me ( in the DBManager package. )

I think this needs Petar's approval, and this general proposal to the list.

Perhaps we can tag this into 6.0.0int4 ?</pre>


<!-- Date: Mon Dec 13 11:13:46 2004 -->
<pre>i have updated the logfile for the ORA-12571 errors on 'lnx1.  you can   
view this latest data at 
 
http://www-css.fnal.gov/dsg/internal/cdfrep01/logbook/  
alert_tns_packet_failure.htm 
 
there was a rash of these errors from mit over the weekend, coming from   
hostnames like 'mitfarm037'.  the executable name for most of them was 
 
/home/bottom/stn/mc/exe/cdfSim_5.3.1patch 
 
unfortunately, the username logged was one of the cafuserN names each   
time.  a couple of the executables did contain the extra string   
'_sasha' though.  perhaps someone knows of a sasha at mit? 
 
./exe/cdfSim_sasha@mitfarm042 
 
-- 
richard 
 
</pre>
<!-- Author: rjetton  -->


<!-- Date: Mon Dec 13 12:28:53 2004 -->
<pre>Rick St Denis asked to be removed from this list. 
 
I noticed only Dmitri was left.  This is the mail list that is used  
to send OEM/Toolman  (db monitoring) events to cdf offline i.e. 
that is the  production events not the dev & int. 
 
Generally, the rule is application people with responsibility get 
events along with the dba's. 
 
Rick suggested I add Art, if Art says ok  I will also add him. 
 
There is also a cdfonoem maillist for cdf online db alerts, I will 
add you there as well?!  
 
 
cdfonom 
hypertxt@B0DAU30.FNAL.GOV (No Name Available) 
litvinse@FNAL.GOV         Dmitry Litvintsev 
rlc@FNAL.GOV              Ray Culbertson 
torretta@FNAL.GOV         Donatella Torretta 
 
 
cdfofoem  
hypertxt@B0DAU30.FNAL.GOV (No Name Available) 
litvinse@FNAL.GOV         Dmitry Litvintsev 
petar@FNAL.GOV            Petar Maksimovic 
 
oem-admin  
Diana@FNAL.GOV   Diana  Bonham  
jtrumbo@FNAL.GOV Julie Trumbo 
nelly@FNAL.GOV   Nelly Stanfield 
rjetton@FNAL.GOV Richard Jetton 
akumar@FNAL.GOV  Anil Kumar  
 
In summary, oem-admin gets all alerts and then cdfofoem 
(application responsible cdfoffline)  cdfonoem (application responsible 
cdfonline) get those from the appropriate db's.   
 
Thanks 
Nelly</pre>
<!-- Author: ns  -->


<!-- Date: Mon Dec 13 12:55:21 2004 -->
<pre>The FRONTIER_PRD account  needs to be created in CDFOFPRD and the table(s) imported from CDFREP01.FRONTIER_PRD into it.  
Done .  
The DBFRONTIER account needs to be created in CDFOFPRD and given read access to the FRONTIER_PRD tables.  
Done.  
The replication procedures between the to database FRONTIER_PRD account needs to be setup.  
Done.  
  
Please verify. If OK then FRONTIER_PRD's table on cdfrep01 will be dropped.  
  
Note : To use the failover, Frontier should use cdfofread as the connect string. Actually this is the name of  
       the service which is configured for failover between cdfrep01 and cdfofpr1  
  
</pre>
<!-- Author: akumar -->

<!-- Date: Mon Dec 13 13:08:49 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 631 
WARNING 
Dec 13 2004 01:08:19 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Dec 13 13:13:30 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 512 
CLEARED 
Dec 13 2004 01:13:18 PM 



</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Mon Dec 13 16:24:19 2004 -->
<pre>fcdflnx1 going down for o/s upgrades, richard will stop the listener make sure everyone moves over to cdfofpr1 then apply 
so no interruption expected </pre>
<!-- Author: rjetton -->
<!-- Comment: Mon Dec 13 17;09;13 comment by...rj  -->
<pre>fcdflnx1 reboot is done and Richard Jetton is checking the status.

Candies</pre>
<!-- Comment: Mon Dec 13 21;27;17 comment by...ns  -->
<pre>Art,

We can check the load on these machines for future
downtimes altho'  since we have the failover in place
we felt comfortable moving forward with the o/s
upgrade.  In fact, we believe that  fcdfora4 can
handle the load.

We will make sure to give a longer maintenance
notice and be  more cautious regarding the usage
of SAM/DH  master node.

-Nelly



----- Original Message -----
From: "Art Kreymer" &lt;kreymer@fnal.gov&gt;
To: &lt;cdfdb-support@fnal.gov&gt;
Sent: Monday, December 13, 2004 6:03 PM
Subject: Re: o/s upgrade on fcdflxn1 - no interruption expected


&gt; On Mon, 13 Dec 2004 DetSys@fnal.gov wrote:
&gt; ...
&gt;&gt;
&gt;&gt; http://www-cdfonline.fnal.gov/cgi-bin/det-system-elog.pl?nb=database&action=view&page=592&anchor=16:24:19
&gt;
&gt; This announced the fcdflnx1 upgrade, with failover to fcdfora4.
&gt;
&gt; It would have been prudent check the load on fcdflnx1 first, at
&gt;
&gt; http://cdfcaf.fnal.gov/cgi-bin/caf/admin/graphs.py?nobatch=1&noAggAvg=1&stat0=load_average&stat1=cpu&stat3=netxfer&nodeutil1=fcdflnx1
&gt; ( The monitoring needs be be restarted after this afternoon's reboot. )
&gt;
&gt; At the time of the upgrade, the fcdflnx1 load average was about 10
&gt; due to a flood of jobs running TRGSim++
&gt;
&gt; The load average on fcdfora4 went from a baseline of 1.5,
&gt; to about 13 during the upgrade, see
&gt;    http://fcdfmon2.fnal.gov/?r=day&c=CDF+CAF+Central&h=fcdfora4.fnal.gov
&gt;
&gt;   It would have been better not to do this to the SAM/DH master node.
&gt;
</pre>
<!-- Date: Mon Dec 13 16:43:52 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=7039 sec, SCN: 0x050e.8b6635f2):. 
WARNING 
Dec 13 2004 04:43:48 PM 



</pre>
<!-- Author: oem-admin (email) -->




<!-- Date: Tue Dec 14 00:03:56 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 14 2004 12:03:48 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Tue Dec 14 00:17:34 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 14 2004 12:03:16 AM 



</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Tue Dec 14 10:17:53 2004 -->
<pre>Applied the SAM AUTODESTINATION cut against cdfofprd. </pre>
<!-- Author: akumar -->

<!-- Date: Tue Dec 14 16:59:30 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Maximum Extents 
Segment SAMPRD.DFLB_LB_MAX_I in tablespace OPERATIONAL_IDX_01 can only allocate 2 additional extents. Segment CDFOPR.FILE_1_CREATE_TIME in tablespace USERINDEX_01 can only allocate 2 additional extents. Segment CDFOPR.FILE_1_FS_FK_I in tablespace USERINDEX_01 can only allocate 2 additional extents. Segment CDFOPR.FILE_DS_FK_I in tablespace USERINDEX_01 can only allocate 2 additional extents. 
WARNING 
Dec 14 2004 04:59:10 PM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Tue Dec 14 17;03;53 comment by...ns  -->
<pre>from 16 to 32 
&gt; Segment SAMPRD.DFLB_LB_MAX_I in tablespace OPERATIONAL_IDX_01 can only allocate 2 additional extents. 
no action on others </pre>

<!-- Date: Tue Dec 14 17:04:32 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Maximum Extents 
Segment CDFOPR.FILE_1_CREATE_TIME in tablespace USERINDEX_01 can only allocate 2 additional extents. Segment CDFOPR.FILE_1_FS_FK_I in tablespace USERINDEX_01 can only allocate 2 additional extents. Segment CDFOPR.FILE_DS_FK_I in tablespace USERINDEX_01 can only allocate 2 additional extents. 
WARNING 
Dec 14 2004 05:04:10 PM 



</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Tue Dec 14 20:09:19 2004 -->
<pre>Added the following tables to int and prd (newer versions than are on dev): 
 
TdcCemSlewing, TdcPemSlewing, TdcCemEfficiency, and TdcPemEfficiency 
 
Also added the process name L3_PHYSICS_CALTDC 
 
to integration. 
 
Please trigger replication.</pre>
<!-- Author: msmartin -->

<!-- Date: Wed Dec 15 00:03:33 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 15 2004 12:03:16 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Dec 15 00:03:58 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 15 2004 12:03:48 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Dec 15 06:48:45 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 670 
WARNING 
Dec 15 2004 06:48:18 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Dec 15 07:13:35 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 988.000000000000000000000000000000000001 
CRITICAL 
Dec 15 2004 07:13:18 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Dec 15 07:34:16 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 474 
CLEARED 
Dec 15 2004 07:33:18 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Dec 15 15:44:11 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 634 
WARNING 
Dec 15 2004 03:43:18 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Dec 15 16:03:41 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 2 
CLEARED 
Dec 15 2004 03:58:18 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Thu Dec 16 00:03:34 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 16 2004 12:03:16 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Thu Dec 16 00:29:59 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 16 2004 12:03:48 AM 



</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Thu Dec 16 11:33:19 2004 -->
<pre>assigned filecatalog_read role to samread on all 3 instances, 
cdfofdev, cdfofint & cdfofprd. 
 
---   
 
Dear Database Administrators, 
 
Would you please grant the 
    filecatalog_read 
role to Oracle account 
    SAMREAD 
on database instance cdfofprd. 
 
Eric  
 
</pre>
<!-- Author: rjetton  -->
<!-- Comment: Thu Dec 16 11;44;09 comment by...Alan Sill -->
<pre>Hmm...  I must be confused.  The only role I can see gratned to CDF_READER, for which this function seems to work OK, is

select granted_role from dba_role_privs where grantee='CDF_READER';

returns

SELECT_CATALOG_ROLE

However, with respect to the role being discussed here,

select grantee from dba_role_privs where granted_role='FILECATALOG_READ';

returns

GRANTEE
------------------------------
CSL
CDFMC
CDFSOFT
SAMREAD
FILECATALOG
FILECATALOG_READUSER

(Possibly SAMREAD has just been added.)

Q: Why does the example script work for CDF_READER, for whom the FILECATALOG_READ role has not been granted?

Apologies if I am confused here... I thought the request would be for SELECT_CATALOG_ROLE, based on the observation that it works for CDF_READER (please correct if I am wrong).
</pre>

<!-- Date: Thu Dec 16 15:53:38 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 610 
WARNING 
Dec 16 2004 03:53:18 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Thu Dec 16 16:03:44 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 220 
CLEARED 
Dec 16 2004 04:03:19 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Thu Dec 16 16:28:37 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 809 
WARNING 
Dec 16 2004 04:28:19 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Thu Dec 16 16:38:23 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 973.000000000000000000000000000000000002 
CRITICAL 
Dec 16 2004 04:38:18 PM 



</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Thu Dec 16 16:41:17 2004 -->
<pre>new account created 
added to cdfdb-users 
Dear CDF Dbers, 
 
Could you please create an account for 
Peter Wagner &lt;wagnp@fnal.gov&gt; on cdfonprd 
with HDW_MANAGER role? 
 
Thanks, and happy holidays, 
Bill</pre>
<!-- Author: ns  -->

<!-- Date: Thu Dec 16 17:03:49 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 76.00000000000000000000000000000000000003 
CLEARED 
Dec 16 2004 05:03:18 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Fri Dec 17 00:05:21 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 17 2004 12:03:16 AM 



48 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Fri Dec 17 00:05:21 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 17 2004 12:03:16 AM 



48 AM 



</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Fri Dec 17 10:49:59 2004 -->
<pre>cdfonprd 
slava77 - already had the role 
khotilov - created & granted   
wagnp - assigned the role 
 
cdfondev  
accounts externally authenticated  
and they get calib_write 
all NEW accounts  
 
 
cdfonint 
slava77 - already had the role 
khotilov - created & granted 
wagnp - created & granted 
 
 
 
----- Original Message -----  
From: "Matthew S Martin" &lt;msmartin@fnal.gov&gt; 
To: "Anil Kumar" &lt;akumar@fnal.gov&gt;; "nelly stanfield" &lt;nelly@fnal.gov&gt; 
Cc: "Petar Maksimovic" &lt;petar@fnal.gov&gt;; "Mat Martin" &lt;msmartin@fnal.gov&gt; 
Sent: Friday, December 17, 2004 10:24 AM 
Subject: Roles email resend. 
 
 
&gt; Hi Anil and Nelly, 
&gt;                                I sent these to the  
&gt; cdfdbb_support@fnal.gov address, but something didn't work I guess. Here  
&gt; are the requests: 
&gt;  
&gt; Hi Anil and Nelly, 
&gt;                              We need the following users: 
&gt;  
&gt; 1) Slava - slava77 
&gt; 2) Vadim - khotilov 
&gt; 3) Peter - wagnp 
&gt;  
&gt;  
&gt; To be granted the role 
&gt;  
&gt; CALORCALIB_WRITE 
&gt;  
&gt; on all databases. 
&gt;  
&gt; khotilov doesn't have an account on the database I think, so will have  
&gt; to be created. 
&gt;  
&gt; cheers 
&gt;  
&gt; Mat 
&gt;  
&gt;  
&gt;  
&gt;  
&gt;  
&gt;  
&gt; And........ 
&gt;  
&gt;  
&gt;  
&gt; Hi Anil and Nelly, 
&gt;                              For the following users: 
&gt;  
&gt; 1) Larry  - ljn 
&gt; 2) Steve Kuhlmann - kuhlmann 
&gt; 3) Minsuk - mskim 
&gt; 3) Willis - willis 
&gt;  
&gt;  
&gt; All these users exist in the database. 
&gt;  
&gt; Please grant them the SHMAXCALIB_WRITE role 
&gt;  
&gt; (most important on the cdfonprd database). 
&gt;  
&gt; cheers 
&gt;  
&gt; Mat 
&gt;  
&gt;  
&gt;  
&gt;  
&gt;  
&gt;  
&gt;  
&gt;  
&gt;  
&gt; cheers 
&gt;  
&gt; Mat 
&gt;  
&gt;  
&gt;  
</pre>
<!-- Author: ns  -->


<!-- Date: Fri Dec 17 14:23:33 2004 -->
<pre>Maurine & Richard just informed me that the new cdfonline machine is at FCC.      
 
It needs to be checked in, tagged, & shipped to b0 bldg. 
 
Stephen Lammel is working with Rob Roser to define the exact 
location for this machine and we hope to start unpacking 
early next week. 
 
We will proceed in defining the plan to burn this machine in. 
 
Currently, we plan to follow our standards so the machine name will be b0ora1.  There is also the alias b0cdfonprd currently in place which we will relink at the appropriate time.   
 
Maurine will folllow up with Sun to understand what support we get to get the machine & disks configured.  
 
More later... 
</pre>
<!-- Author: nstanfield  -->


<!-- Date: Fri Dec 17 15:33:01 2004 -->
<pre>At the last cdfdbmtg it was requested that we consider 
replicating sam schema from cdfofprd to cdfrep01. 
 
After further discussion it is not an issue replicating all of  
the sam tables, and in fact this will ensure that all used 
cases are covered.  There is enough space & the dbrep 
tool is currently designed to replicate schemas vs specific 
tables. 
 
In addition, Anil points out that the streams 
deployment is setup for schema replication not tables, 
so if we proceed with a schema deployment now we can 
easily incorporate this into our future streams deployment.  
 
full sam schema size   --&gt; 10G   
 
vs  
 
only specific tables:  
&gt;     DATA_FILES                 520M     data_files_p01)  
&gt;     DATA_FILES_RUNS             51M     (operational) 
&gt;     PARAM_VALUES               409M     (support_01) 
&gt;     REQUEST_DETAILS              6M     (operational) 
&gt;     DATA_FILES_PARAM_VALUES    134M     (operational) 
 
Pro's  
 
greater reliability of the database for the users (because of failover).  
 
also, such replication makes it easier to schedule down-times 
for databases, and the unscheduled down-times don't cause a 
big crisis.  
 
Con's 
 
  
</pre>
<!-- Author: nstanfield/akumar  -->
<!-- Comment: Fri Dec 17 18;53;08 comment by...Alan Sill -->
<pre>OK for read.  How will you synchronize writes?</pre>

<!-- Date: Sat Dec 18 00:03:43 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 18 2004 12:03:17 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sat Dec 18 00:04:41 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 18 2004 12:03:48 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sat Dec 18 07:08:36 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 605 
WARNING 
Dec 18 2004 07:08:18 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sat Dec 18 07:13:32 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 499 
CLEARED 
Dec 18 2004 07:13:18 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sun Dec 19 00:03:42 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 19 2004 12:03:16 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sun Dec 19 00:04:19 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 19 2004 12:03:48 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sun Dec 19 02:08:34 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 656 
WARNING 
Dec 19 2004 02:08:19 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sun Dec 19 02:13:25 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 517 
CLEARED 
Dec 19 2004 02:13:18 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Dec 20 00:04:59 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 20 2004 12:03:16 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Dec 20 00:04:59 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Dec 20 2004 12:03:49 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Dec 20 01:48:42 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 610 
WARNING 
Dec 20 2004 01:48:18 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Dec 20 01:48:42 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 610 
WARNING 
Dec 20 2004 01:48:18 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Dec 20 01:54:55 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 427 
CLEARED 
Dec 20 2004 01:53:18 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Dec 20 01:54:55 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 427 
CLEARED 
Dec 20 2004 01:53:18 AM 



</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Mon Jan 24 17:26:53 2005 -->
<pre>New account added for Bob Wagner (rgw) with cdf_trigger_maker role; this role was added to the S. Lee (slee) account also.</pre>
<!-- Author: Richard Jetton -->