For 3421, international students are invited to participate in student exchange program. For July 2013, we have 5 international students Wireless accounts are requested for the students since they are not registered in the course via SIS. For York Students, they register via SIS and hence has wireless accounts with York already.

Once the wireless accounts are generated (via a request through ithelp) We use the same account but drop the first character to create local accounts within CSE. The reason being is that DB2 will not accept names with more than eight characters.

So as an example , it the generated YU (wireless) account is

 yc0133569 , the Lassonde account is c0133569. The first character is dropped .

The password is kept the same for simplicity

These names will be passed to the Professor for distribution.

Within Lassonde EECS, access is granted to these students to LAS2007 for the duration of the course. Our York students will be given access automatically being in a 3rd year course.

The database created is c3421a All CSE3421A registered students have access to this database

Please observe the operating system you are using when logging in.

Linux Hosts

In the PRISM Lab (LAS1006,LAS1004), you will be able to access the database via Linux Hosts

You will login with your LAS userid provided. This id is 8characters. (The yc0xxxxxx account is your wireless account). Password for both accounts are the same

It is important to use the 8 character userid because the database will not accept any account name greater than 8 characters.

Once you are logged in, to connect to the database created for your classroom

 At the $prompt, this is your Home Directory where data is
    backed up . Any scripts you write here will be saved.

 Execute the following command

  $ db2 connect to c3421a 
         will return 

    Database Connection Information

    Database server        = DB2/LINUXX8664 10.1.0
    SQL authorization ID   = c01xxxxxx
    Local database alias   = C3421A

  From here you can proceed to creating tables.

  Alternatively,
  You can use DB2 interactively

$ db2

       db2 =>

Windowx XP

These machines are in LAS1002 (aka miss{01-33}), 
LAS2007 (ns09-12).
In order to connect to the database 
Use the same LAS userid as the linux hosts

You must run the Xserver from the desktop

Doubleclick the "StartX " icon on Desktop
You will see an "X" at the bottom bar of the computer.

Next you will Doubleclick on "Putty X11Forwarding" icon
Once a terminal window is opened 

 Hostname : red.cse.yorku.ca
 Click on Open 
 
 An xterminal will open up for you
 From the $prompt,
 
 $ db2 connect to c3421a
    will return 

    Database Connection Information

    Database server        = DB2/LINUXX8664 10.1.0
    SQL authorization ID   = C01xxxxxx
    Local database alias   = C3421A

 You are in your home directory at this point. 

Windows7

The first 8 computers in LAS2007 is running windows7

Login as above with your LAS userid (c01xxxxx)

From the Desktop, there is a folder called “Shortcuts” Inside Shortcuts, you will find the Xserver and Putty Application

First start the Xserver

 Doubleclick on XwinServer
    You will see the "X" logo at the bottom tray

Second

 Doubleclick "Open Xterminal-on-red"

 This will give you an xterminal to work with