University of Houston Learning' Leading

1
University of Houston Learning. Leading

• PeopleSoft
• Technical Architecture Overview
• Lupe Sosa
• Technical Integration Manager
• www.uh.edu/fast/FAST-technical.htm
• Lsosa_at_uh.edu

2
Topics

• UH System Overview
• Hardware
• Software
• Databases
• Performance Tuning
• Data Network
• Project Organization
• Technical Staffing
• Challenges

3
UH System Overview
W2s 15,200 Students 52,000 Students
Registered 8,000 (UHCL only) Vouchers
170,000 / yr Vendor Checks 100,000 /
yr POs 21,500 / yr
4
UH Central Campus
Offers bachelor's, master's, doctoral, and
professional degrees through 13 colleges, on
campus and via distance education, plus
non-credit continuing education courses. Number
of students 32,000 Website www.uh.edu
5
UH - Downtown
Offers both bachelor's and master's degrees in
downtown Houston. The second largest university
in the UH System. Number of Students
9,000 Website www.uhd.edu
6
UH Clear Lake
Offers more than 30 undergraduate and over 40
graduate majors. Located midway between Houston
and Galveston, the campus is next to NASA's
Johnson Space Center and the Armand Bayou Nature
Center. Number of Students 8000 Website
www.cl.uh.edu
7
UH - Victoria
Offers upper-level and graduate courses within
the Coastal Bend region, including collaborative
programs in Fort Bend County. It serves
students who have completed two or more years of
college, providing bachelor's degrees, master's
degrees, and professional certification programs.
Number of students 2000 Website www.uhv.edu
8
UHS - Sugarland
Offers junior, senior, and graduate level classes
leading to 32 bachelors and masters degrees.   Is
a multi-institutional system center for UHS that
combines the educational resources of the four
UHS universities. Website http//www.uhsa.uh.e
du/fb/
9
UHS Cinco Ranch
Is a partnership among the four UH System
universities to collaboratively deliver courses,
certificates, degrees, and noncredit training at
in Cinco Ranch. Combines the educational
resources to deliver junior, senior, and master's
level classes leading to bachelor's and master's
degrees, as well as all levels of training for
the corporate world. Website
http//www.uhsa.uh.edu/cr/
10
Production Hardware Environment
ES10000 Starfire Production Server (4
domains) 32 GB RAM / 32 CPUs (466 Mhz) FS 10
GB/ 12 CPUs - HR/SA 12 GB / 16 CPUs ES6500
Reporting Database / Failover 20 GB RAM / 20
CPUs (466 Mhz) E420R (x2) Production
Application Server (Load Balanced) 4 GB RAM / 4
CPUs (466 Mhz) E420R Production Process
Scheduler 4GB RAM/ 4 CPUs (466 Mhz) E420R Tape
Server 4 GB RAM / 4 CPUs (466 Mhz)
11
(No Transcript)
12
Development / Test Environment
(1) E420R Development Server 4 GB RAM / 4 CPUs
(466 Mhz) (1) E420R Test Server 4GB RAM / 4
CPUs (466 Mhz) (1) E420R Training Server
4GB RAM / 4 CPUs (466 Mhz) (1) E420R
Process Scheduler / Application Server 4GB RAM /
4 CPUs (466 Mhz)
13
Production NT Servers
(1) ML370R Master File Server 1 GB RAM / 1
CPUs (733 Mhz) / 50GB (4) ML370R Production
File Servers (1 per Campus) 1 GB RAM / 1 CPUs
(733 Mhz) / 50GB (4) ML370R Production Process
Schedulers (1 per Campus) 1 GB RAM / 2 CPUs
(733 Mhz) / 50GB (2) ML370R Production Web
Server 1 GB RAM / 1 CPUs (733 Mhz) / 12GB
14
Software Environment

• PeopleSoft (Financials v 7.52, HR/SA v 7.6)
• GL, Purchasing and A/P
•   Admissions, SR, SF and AA (UHCL only)
• HR, Payroll, and Base Benefits
• Future
• Admissions, SR, SF, AA, Financial Aid (PS 8)
• A/R, Asset Management, Billing, Inventory and
  Project Costing
• Benefits Administration Time and Labor (PS 8)
• Database - Oracle 8i (v 8.1.6)
• O/S - SUN Solaris 2.6
• Desktop O/S - 95/98/NT/2000/Macs

15
Database Instances
Test Development Train
Production Reporting
Sandbox Demo
Application Update Conversion
16
Performance Tuning (UNIX)
msgmap 200 msgmni 100 msgtql 80 msgseg
2048 Shmmax 268435456 ? 6442450942 shmseg
256 semmap 128 semmni 1000 Note Do not try
this at home!!!
17
Performance Tuning (UNIX)
semmns 4000 ? 17920 semmnu 800 semmsl
512 semume 100 shmmin 1 shmmni
128 semopm 100 semvmx 32767
18
Performance Tuning (Oracle)
SHARED POOL 512M ?
1G SORT_AREA_RETAIN 4M ?
8M SESSION_CACHED_CURSORS
400 DB_BLOCK_BUFFERS 45K ?
90K DB_BLOCK_LRU_LATCHES 16 ?
24 LOG_BUFFER
163K ? 1M LOG_CHECKPOINT_INTERVAL 61K ?
500K
19
3rd Party Software

• Report.Web (Reports Distribution)
• Ad Astra (Room Scheduling)
• CyberSource (Web Credit Card Processing)
• First Logic Postal (Address Verification)
• EPOS first line (Telephone Registration)
• Sterling Commerce GenTrans (Transcripts)
• Crystal / SQR / nVision (PS)
• Veritas NetBackup / Volume Mgr (SA)
• Embarcadero (DBA)
• Foglight/Spotlight (evaluating)

20
Data Network
T1 1.5 Mbps OC3 155 Mbps
21
(No Transcript)
22
Technical Staffing
Technical Managers 5 Lead DBA 1 DBA 2 Devel
opers 12 Database Analysts 2 Unix / NT
Admins 4 Security Admins 2 Desktop
Support 7 Network Support 1 Help
Desk 7 Trainer/Coordinator 1 Consultants 6
Not all are FTE or Project Staff
23
Challenges

• Performance Tuning
• Patches Patching Patches
• Consultants rolling off
• PS 8

24
Conclusion
Change is not necessary. Survival is not
mandatory. - Charles Darwin