Steps for accessing Egret (DB2 and Windows File Share)



Steps for accessing Egret (DB2 and Windows File Share)

Important Note

Make sure you are using a computer in the CSUGLab or CSUGLab annex that has DB2 for Windows NT in Start Menu->Programs. If you are not inside the CSUGLab firewall, you will NOT be able to access the server in any way.

Accessing your Windows File Share

To post new HTML, Servlets, or JSP pages, you will need to mount your Windows File Share. To do this you will need your group name (G7 for example), and the userid and modified password we gave back to you on your project proposal cover sheet (the passwords were modified to be 8 characters per request of the CSUGLab administrators).

1. From your desktop, right click on My Network Places and choose Map Network Drive…

2. Choose a drive letter (say, G: )

3. In the folder line, enter: \\egret.csuglab.cornell.edu\ where is your group name. For example, if you are group 7, you should enter: \\egret.csuglab.cornell.edu\g7

4. Click on the “Connect using a different user name” link and enter your userid (your netid example cucs\mb103), and your modified password. Then click OK.

5. Click on Finish to mount your network drive.

Accessing DB2

To access DB2 to create tables, insert data, or add stored procedures, you will need to follow the following steps:

First you must configure your ODBC connection.

1. From the Start menu, choose Program Files -> DB2 for Windows NT -> Client Configuration Assistant.

2. Click the Add… button

3. Click on the Manually configure a connection to a DB2 database option and then Click Next

4. Choose TCP/IP for your protocol and click Next

5. Enter the following information:

Hostname: egret.csuglab.cornell.edu

Port number: 50000

Service Name:

Click Next to continue.

6. Under Database Name, enter your group name (i.e. G7, G23, etc.). Click Next to continue.

7. Make sure the Register this database for ODBC box is checked, along with the As a system data source option. Click Next to continue.

8. You can leave the “Node Options” stuff blank. Click Next to continue.

9. Under security options, click the Configure security options box and make sure the Use the server’s DBM configuration is chosen. Click Done when you are finished.

10. You may now test your configuration using one of your netid/password combinations. Click the Close box once youa re finished.

To access DB2, go to Start -> Program Files -> DB2 for Windows NT -> Command Line Processor. To log-in to DB2, issue the command:

connect to user using

where is your group name (i.e. G7), is your netid, and is the password we gave you in your proposal.

Once you do that, you will be able to add tables, insert data, and issue other SQL commands.

One word of caution: each user is a local database administrator, and so tables created by one administrator may not be directly seen by other administrators. For example, if the two users xxx1 and yyy2 are in group G50 and xxx1 creates a table named “Users”, then for yyy2 to access it, she needs to write something like: select * from xxx1.Users. (notice how the table name is prefixed by the administrator who created the table. However, user xxx1 can continue to access the table as: select * from Users. It might be easier if you limit all of your administration to one user so you do not need the prefixes.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download