> Any suggestions on what I 'should' learn immediately will be  
> greatly appreciated. 
 
I think you should focus on a clear understanding of the processes you have
to run on a regular basis as the sysop/DBA. These are: 
 
1) Routine maintenance, backup, and operational tasks. 
2) Common diagnostics and interventions for typical problems.  
3) Defensive Measures 
4) Conceptual Overview 
 
 
1.1) Database performance maintenance: optimizedb, sysmod, modify. 
1.2) Backup and Recovery 
1.3) OS Level Maintenance Tasks 
1.4) Starting and Stopping Servers 
 
2.1) Diagnosing Locking Problems through IPM 
2.2) Diagnosing Thread States through IPM 
 
3.1) Groups, Roles, and Resource Limits 
3.2) Uses and Abuses of Ingres Net Management Utilities 
3.3) Password Protection 
3.4) The Perils of Permissions: DBA, SuperUser, and Trace Point 
 
4.1) Ingres Processes, and What They Do 
4.2) Relationship With Operating System 
4.3) Internal Architecture 
 
The other thing you're got to do is understand the applications that run on
this system, and the business expectations it is to meet. 
 
Hope this helps. 
 
-- 
James Bullock - Rare Bird Enterprises 
620 Park Avenue # 171 
Rochester, NY. 
716-242-4824 
716-244-9072 (Fax) 

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William