Differences

This shows you the differences between two versions of the page.

--- software:db2:international_students [2013/06/28 11:56] – created seela
+++ software:db2:international_students [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-====== International Students ======
-====General Information====
-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.
-==== Creating a Database for 3421 ====
-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