MAP | CALMAIL |
     
search
Tutorials - DB2/OLADS

DB2 - Tele-BEARS/OLADS Information Page

General Information

DB2 is the primary student database system used by staff in academic and administrative departments. You use DB2 to access such data as students’ class schedules and academic transcripts, as well as class enrollment and waiting list information. Your level of access is determined primarily by your job function and must be approved by your supervisor and department head.

Who uses the system and when?

Use the following chart to determine which level of access would work best for the needs of your job. Find the access package (listed across the top) that most closely encompasses the functions you need (listed in the first column). If you are unsure whether any of the listed functions are needed for your job, consult your supervisor. In addition, there are recommended packages listed below the chart for the most typical users.

Access

You must complete a CICS User ID Name Request form and a Request for Student Database (DB2) Access form. You can download these forms below; be sure to download the appropriate DB2 Access form for your department.  When completed, the forms can be sent or emailed to Doug Au, Office of the Registrar, 119 Sproul Hall, MC 5404.

CICS User ID Name Request form (MS Word)

AND one of the following three

Request for DB2 Access—Academic Departments
Request for DB2 Access—Colleges & Schools
Request for DB2 Access—Administrative Offices

You are required to have completed FERPA training before you are granted access to the DB2 Student Database. The FERPA course is online, and can be accessed via the UC Learning Center. Log in with your CalNet ID and passphrase, and look for the course entitled Privacy of Student Records: Are you Revealing Too Much?, the mandatory training to learn about compliance with Family Educational Rights and Privacy Act (FERPA).

Software Needed

Macintosh users should have tn3270 X. You can download the latest version from Brown University at http://www.brown.edu/Facilities/CIS/tn3270/. PC users should have Host Explorer by Hummingbird. You can download the latest version from Berkeley's IST Software Central page.

With either the Mac or the PC version, enter "uccmvsb.ucop.edu" as the host name, if prompted. With tn3270 (Mac), be sure to enable SSL (via the "Special" icon) upon initial launch of the program. For further instructions on connecting, please visit the Mainframe FAQ.

Training

Training on DB2 and Department Scheduling is done on an individual, one-on-one basis.  Contact Doug Au at 510.643.4294 or dougau@berkeley.edu (for DB2) or Susan Tonus at 510.642.0313 or tonus@berkeley.edu (for scheduling) to schedule an appointment.
 

Instruction Manual

Contact

  • Contact Doug Au at 510.642.7009 or dau@berkeley.edu for technical assistance.

 

This page was last updated on Monday, August 11, 2014