Support
IBM DB2 and Timesheet

IBM DB2 Universal Database Instructions

1. Make sure you have read the general instructions here.
2. Install IBM DB2 version 6.1 or higher if not already installed. Change the passwords for the administrator account db2admin if that has not been done yet. Note: this guide was prepared using version 6.1 of IBM DB2. Some parts of the Control Center may be labeled differently in later versions.
3. Launch the DB2 Control Center program and log in with the db2admin account to the specific DB2 instance that you wish to use with Timesheet. NOTE: this database may have a separate password than you used to launch Control Center.
4. Browse under the Systems pane on the left side of the Control Center screen. Under your database server's name, open the Instances folder, then open DB2, then open Databases, and finally open the specific database that you wish to use.
5. Create a buffer pool with 8KB Page Size
   • Journyx Timesheet requires a tablespace with at least 8kb pages, which is not the default for DB2. In order to create a tablespace with an 8kb page size, you must also have a buffer pool with an 8kb page size.
   • See this article for more info on DB2 table spaces and buffer pools.
   • Under your specific database, click the Buffer Pools folder.
   • If the only buffer pool is IBMDEFAULT then you most likely need to create a new pool. (You can check the page size of any existing pool by right-clicking then selecting Alter...) The page size will be listed, but not changeable.
   • To create a new buffer pool, right-click on the "Buffer Pool" folder name and select Create...
   • Give it any name (TS_BUFFER will work).
   • It is important to make sure 8kb page size is selected. Higher values will also work, but lower values will not.
   • You may leave the "size in pages" option to be the default 250.
   • Click "OK" to create the buffer pool.
   • Note: you must restart the DB2 instance in order for it to "see" the new buffer pool! Under "Instances" (on the left hand pane) right-click on your instance, then click Stop.
   • Make sure "disconnect all applications" is checked, then click OK.
   • When the database has stopped, dismiss the notification dialog, then open the same menu and click Start. Your new 8kb buffer pool should now be online, and you can proceed to creating a Table Space.
6. Create a Table Space for the Journyx Timesheet user.
   • Journyx Timesheet requires a table space with an 8KB page size. By default, most table spaces in DB2 have a 4KB page size. If you attempt to use a table space with too small a page size, you will get a SQL error from DB2 during the Journyx Timesheet Database Setup script.
   • The objective of this section is to identify a table space with an 8KB page size that we can use, and to create one if one does not already exist. You must specify the exact name of the table space (which must have an 8KB page size) when you describe your ODBC data source in the Journyx Timesheet Database Setup script.
   • Under your specific database, click on the Table Spaces folder. You may see several table spaces listed. You can right-click on each one and select "Alter..." to view its characteristics. If you already have a table space that has an 8KB page size, then you can use that table space (and skip to the next step.) If you are at all unsure, go ahead and create a new table space for Journyx Timesheet's private use.
   • Right-click on the Table Spaces folder under your database. Click Create, then "Table Space". Give a name to the table space such as TIMESHEET. Keep the default "Regular" type and "System" management options.
   • Click the Advanced... button.
   • For Page Size, make sure 8KB or higher is selected. You will have to already have an active buffer pool with that page size (or higher) in order to be able to create a table space with an 8KB page size.
   • The only other option you need to select here is "Buffer Pool" ... make sure that you select the 8KB page size buffer pool that you created in the last step (TS_BUFFER.)
   • Click OK to leave the Advanced menu.
   • Finally, you need to select a "Container" for the table space, which is usually a file on a disk.
   • Next to Container Name, click Add...
   • Select a disk and directory to store the TIMESHEET table space. Give a name to the container as well (TIMESHEET will also work for this.)
   • Click OK to add the container. You may add any additional containers if you wish.
   • Click OK to create the Table Space. You will need to provide the name of the Table Space you just created when you run the Journyx Timesheet Database Setup script.
7. Create a Journyx Timesheet user.
   • Normally, in DB2, users are authenticated by the "system" authentication. That means that the username and password that you would use to log on to your Windows Domain (or DB2 host) is the same that you would use to actually access the database.
   • However, you must still add a DB2 user record in order to connect. So, you must decide which user account on your system that Journyx Timesheet will use to connect to the DB2 database. See your Windows network administrator to establish an account and password.
   • Once you have decided on an account name, click on the "User and Group Objects" folder under your database instance. Under that folder, select "DB Users."
   • Right-click on "DB Users" and select "Add...".
   • Click on the default user name (usually "GUEST") and type in the username that you wish to use.
   • Make sure these Authorities are checked:
     • Connect Database
     • Create Tables
     • Create Packages
     • Create Schemas Implicitly
   • You may leave all the other options alone and click OK to create the user.
8. Follow the rest of the general setup instructions here.