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. This is in the event
they would like to use AirYorkPLUS - York's wireless service

For York Students, they register via SIS and hence has wireless accounts
with York University 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 Lassonde EECS. The reason being is that DB2 will not accept 
names with more than eight characters. We have no control on the 
length of the usernames generated by ithelp.

So as an example , the generated YU (wireless) accounts start with

   yc0133xxx .

The Lassonde EECS account is 

   c0133xxx. 
The first character is dropped The password is kept the same for simplicity
The username field is case-sensitive

These names will be passed to the Professor for distribution.

Within Lassonde EECS, access is granted to CSE3421A students to 
access Room LAS2007 located on the second floor of the building.
This is for the duration of the course. Our local students will 
be given access to LAS2007 as well.

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 Lassonde EECS 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 DB2 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 Lassonde EECS userid as the linux hosts
  
  You must run the Xserver (icon on 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 x terminal 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 Lassonde EECS 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