DB2 Data Links Manager Quick Beginnings

Before You Begin

Please read the information in this section before installing DB2 Data Links Manager.

System Requirements

You must be running Windows NT Version 4.0 with Service Pack 5 or later. To check the level of the operating system, double-click on My Computer and select Help --> About Windows NT from the menu bar.

NTFS Formatted Drive

You must have at least one Windows NT Filesystem (NTFS) formatted drive that will be controlled by a Data Links Filesystem Filter (DLFF). Any drive that a DLFF will control must be an NTFS formatted drive. During the installation, you can select the drives that you want to be controlled by a DLFF. If you do not have a drive that was formatted for NTFS, you will not be able to perform the installation.

A separate NTFS drive is also required if you want to store backups of linked files on a local file system.

To view a list of the NTFS formatted drives on your system, click Start and select Programs --> Administration Tools (Common) --> Disk Administrator.

You can either convert an existing file system to NTFS, or create one. To convert an existing file system to NTFS, enter the following command:

   convert x: /fs:ntfs

where x: is the drive that you want to convert to NTFS.

This command must be run on a drive other than the one that you are converting to NTFS.

You can create an NTFS partition using the Windows NT Disk Administrator tool. Refer to the Windows NT online help for more information.

Enable drive sharing

Each drive that you plan to be controlled by a Data Links Filesystem Filter must be enabled for sharing.

To enable a drive for sharing:

1. Click Start and select Programs --> Windows NT Explorer.
2. Select the drive that you want to share, click the right mouse button, and select Sharing. If you are already sharing the drive that you want to be controlled by a Data Links Filesystem Filter, skip the next step and proceed to Step 6.
3. Select Shared As.
4. Click New Share.
5. Enter a share name for this drive in the Share Name field.
6. Click OK.
7. Click Permissions.
8. Select the Everyone option.
9. Click Type of Access and select the Full Control Option.
10. Click OK to register the new share name.

Memory requirements

There must be at least 64 MB of RAM available to your system. To check the amount of memory available to your system, select My Computer, click the right mouse button, and select the Properties option.

Synchronize system clocks

The system clocks on the Data Links server and the DB2 server must be, and remain, synchronized. Synchronization of clocks is essential for the Data Links token expiry interval to work correctly. The token expiry interval is a database configuration parameter. For more information, refer to the Administration Guide.

To set the time for a machine's system clock:

1. Click Start and select Settings --> Control Panel.
2. Double-click the Date/Time icon.
3. Set the local system time using the spin buttons in the Time box. Remember to set this time equal the local system time on the DB2 server.
4. Click on the Time Zone tab and select the appropriate time zone from the drop down box. Remember to use the same time zone setting on all servers.
5. Click OK.

Version levels of DB2 Data Links and DB2 UDB

Version levels of DB2 Data Links and DB2 Universal Database can be any combination of Version 6.1 and Version 7.1. For example, DB2 UDB can be at Version 6.1 and Data Links Manager can be at Version 7.1. To check the version of DB2 that resides on a workstation, enter the db2level command.

User account rights

You need to have a user account that will be used to perform the installation.

The user account you specify must:

1. Be defined on the local machine
2. Belong to the Local Administrators group.
3. Have the following advanced user rights:
   • Act as part of the operating system.
   • Increase quotas.
   • Replace a process level token.
   • Create a token object.
   • Log on as a service.

For more information on Windows NT user rights, refer to the Windows NT online help.

dlmadmin username

During the installation, you will be asked to provide a user account that will be used as the DB2 Data Links Manager Administrator.

By default, the setup program will set up a user account with the username dlmadmin and password dlmadmin. You can accept these default values, specify an existing account, or create a different user account by changing the default values.

If you accept the default dlmadmin user account, you should ensure that you change the Password and Confirm Password fields. The dlmadmin user account's password is dlmadmin for any DB2 Data Links Manager installation and is therefore well known. Using the default setting for this user account could pose a security risk to your network.

If the dlmadmin user account already exists on your system, you must use the password that was previously set for this user account.

If you want to specify an existing user account, the account you specify must:

• Be defined on the local machine.
• Belong to the Local Administrators group.
• Have the "Back up files and directories" and the "Restore files and directories" user rights.
• Have the following advanced user rights:
  • Act as part of the operating system.
  • Increase quotas.
  • Replace a process level token.
  • Create a token object.
  • Log on as a service.
• Have a username that is 30 characters or less.

If you want to create a new user account using the setup program, you must ensure that the username you specify is 30 characters or less.

For more information on Windows NT user rights, refer to the Windows NT online help.

DLFM1 user account

In addition to the DB2 Data Links Manager Administrator user account (dlmadmin), the DLFM1 user account is also created during installation for use by the Data Links File Manager. The DLFM1 user account is the owner of all READ PERMISSION DB files.

TCP/IP port number

You must have a TCP/IP port free for use by the Data Links File Manager. By default, the setup program will generate a value for you. You can use this value or provide your own. You will need to know this port number to verify the installation.

To review the TCP/IP ports that are in use on a machine, open the services file located in the x:\winnt\system32\drivers\etc directory (where x: is the drive where you installed Windows NT).

Determine fully qualified hostname

You must resolve the fully qualified hostnames of your DB2 Data Links and DB2 UDB servers. You will need to know these hostnames to verify the installation.

To resolve these hostnames, enter the hostname command on your DB2 Data Links and UDB servers. For example, this command might return dlmserver on your Data Links server.

Now enter the nslookup dlmserver command, where dlmserver is your hostname. This command should return output similar to the following:

   Server: dnsserv.services.com
   Address: 9.21.14.135
   Name: dlmserver.services.com
   Address: 9.21.51.178

The Name: dlmserver.services.com entry is your fully qualified hostname name.

Repeat these steps on each DB2 Data Links Manager and DB2 UDB server.