Getting started on the IU Research Database Complex

On this page:

Introduction

The Research Database Complex (RDC), part of the Libra cluster, is dedicated to research-related databases and data-intensive applications that require a database. Oracle and MySQL databases are supported, and the default database size is 15MB. The RDC also provides an environment for database-driven web applications with a research focus. This system, rdcweb.uits.iu.edu, runs Red Hat Enterprise Linux 5. User home directories reside on the IBM N5500 NAS storage device, with disk quotas of 10GB per user. This quota is shared by your Big Red and Quarry accounts, if you have accounts on those systems.

The RDC is strictly devoted to supporting research; it is not an instructional or classroom environment. If you need to use Oracle or Microsoft SQL Server in an instructional environment, please see Instructional resources: Database and web server access for instruction.

Access to the RDC is available to all Indiana University graduate students, faculty, and staff. Undergraduates and non-IU collaborators must have IU faculty sponsors. For information about user responsibilities and security issues, see What are the usage policies for IU's Research Database Complex?

Your database login

If you don't have an account on Libra at IU, use the Account Management Service (AMS) to request one. See At IU, if I already have some computing accounts, how do I get others?

If you have an account on Libra but don't have an Oracle or MySQL database login, use the Research Database Complex (RDC) and Web Services Account Application to request one. After UITS staff create your database, you will receive a Welcome letter via email that contains information about your database username and password.

If you have an account on Libra and an Oracle or MySQL database login but don't recall the database password, refer to the database Welcome letter that was emailed to you. If you need help, email the UITS High Performance Systems group.

Connecting to your database

Oracle

For instructions on how to connect to your Oracle database on the RDC, see:

MySQL

For instructions on how to connect to your Oracle database on the RDC, see:

Storing data

Your home directory is on the Libra cluster and resides on the IBM N5500 NAS storage device. You have a 10GB disk quota that is shared with Big Red and Quarry, if you have accounts on those systems.

Scratch file systems are available, but are not backed up to tape. Any data purged from the scratch file systems cannot be recovered. You are responsible for making your own data backups in case of disk failure or purging to free disk space. No disk quotas are enforced on these scratch file systems:

Local scratch: Scratch disk space is available locally on each node in /tmp (1GB), and an additional large scratch file system named /scr (10GB). Files in /tmp are automatically deleted when they are 24 hours old. Files in /scr are deleted when they are 30 days old.
Shared scratch: Shared scratch space is accessible in one 266TB GPFS file system (/N/gpfs). The path to your scratch space is /N/gpfs/username. Files older than 60 days are purged automatically to free disk space.

Support

The UITS High Performance Systems (HPS) group supports and administers the RDC; if you have questions about the system, email HPS. If you have questions about compilers, programming, scientific or numerical libraries, or debuggers, email the UITS High Performance Applications team. If you have questions about statistical and mathematical software, email the UITS Stat/Math Center.

Documentation

Oracle

For further documentation, see the Oracle Database Documentation Library, 10g Release 2 (10.2) and the following online guides:

MySQL

For further documentation, see the MySQL Reference Manual.

This is document awmv in domain all.
Last modified on November 14, 2008.

Please tell us, did you find the answer to your question?