| Q1: |
What username should I use to log on to Windows if I want to use DB2?
|
A1:
|
To use DB2, you must log on to Windows with a username that complies with DB2's naming rules. The most important rule is that the username must have 20 characters or fewer. The username db2admin is usually created during installation, so you may want to log on with this username.
Another factor you should consider is the authority the username has. Many things can be performed only by a username with SYSADM authority. By default, if your username is a member of the Administrators group, it has SYSADM authority. The db2admin username is created in the Administrators group and therefore has SYSADM authority.
|
| Q2: |
What DB2 programs start automatically following a reboot?
|
A2:
|
Following the first reboot after installation, DB2 First Steps is automatically started to allow you to create the SAMPLE database, work with the database, and access the DB2 product library.
Another choice you had during Custom install was whether you wanted the default instance (DB2) and the DB2 Administration Server (DB2DAS00) started automatically. If you used the Typical install type, both instances are started automatically.
|
| Q3: |
How can I view data in the SAMPLE database?
|
A3:
|
DB2 uses SQL to query tables in a database and returns the results to you in the form of a table. You can use SQL in many ways to view the information in a table. First, you can use the Control Center and select to sample the contents of a selected table. By using the Command Center, you can type in SQL statements to CONNECT to a database and SELECT data from a table. If you're registered for ODBC, you can use ODBC-enabled applications such as Lotus Approach or Microsoft Access to view the data. You can view the data in other ways as well.
|
No comments:
Post a Comment