Differences

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

--- software:db2:international_students [2013/06/28 12:08] – 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====
-<code>
-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.
-</code>
-==== Connecting to a 3421 Database====
-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.
-====Logging into Hosts running different Operating Systems====
-**Linux Hosts**
-<code>
-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
-characters. (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 =>
-</code>
-**Windowx XP**
-<code>
-  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.
-</code>
-**Windows7**
-<code>
-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
-</code>