Use the Warehouse target page of the Warehouse Target notebook to add information about the new target warehouse that you are defining to the Data Warehouse Center.
Use the Database page to provide database information for your warehouse.
The Database page of the Warehouse Target notebook is displayed for database warehouse targets only. The Connection page is displayed for flat file warehouse targets.
The Data Warehouse Center uses this information to connect to the database that the Data Warehouse Center will use as a warehouse.
The database that you use as a warehouse must be cataloged in the DB2 directory at the agent site. You must also add an ODBC system data source name (DSN) entry for the database at the agent site. Use the ODBC applet accessible from the Windows Control Panel.
Create
transformers and register as fenced
If you are using an agent other than the AS/400 agent, you must type the system data source name (DSN) by which the database is registered in ODBC on the agent site. This name can be up to 40 characters long.
The DSN must be unique to this warehouse. You cannot use the same DSN for both a warehouse and a warehouse source.
If you are using the AS/400 agent, type the name of the database as it is registered in the remote database directory on the AS/400 agent site. The name can be a maximum of 18 characters. Although the Database field has space for 40 characters, the remote database directory on the AS/400 machine uses database names that are a maximum of 18 characters in length.
Do not change the database name after you specify it. Changing the name can cause errors in the SQL for a step and errors in other definitions.
If your warehouse is defined on a DB2 Common Server, the user ID must have the CREATETAB database-level privilege.
If the database that your warehouse accesses is an AS/400 database, type the user ID in uppercase letters. AS/400 allows only uppercase user IDs.
For example, if you are using an AS/400 database, you must type the password in uppercase letters. AS/400 allows only uppercase passwords.
Create transformers and register as fenced
The transformers are stored procedures that are registered with the database. If a stored procedure is registered as fenced, the database manager insulates its internal resources (e.g. data buffers) from access by the procedure. A stored procedure registered as non-fenced will run in the database manager operating environment process or address space. All procedures have the option of running as fenced or not fenced. In general, a procedure running as fenced will not perform as well as a similar procedure running as not fenced.
Use the Tables page to import or create definitions of tables to include in your warehouse target.
This page is displayed for relational warehouse targets.
Include a particular table definition in only one warehouse target.
Use the Security page of the Warehouse Target notebook to select one or more warehouse security groups that can define processes and change definitions of processes for a warehouse target. For more information, see Data Warehouse Center security.
Use the Agent Sites page of the Warehouse Target notebook to specify which agent sites defined to the Data Warehouse Center have access to this warehouse target.
On this page, you can list currently available agent sites and add agent sites that have access to this warehouse.
When you add an agent site, it is accessible to the warehouse only if the target databases that it uses are cataloged in the DB2 directory at the agent site. You must also add an ODBC system data source name (DSN) entry for the database at the agent site. Use the ODBC applet accessible from the Windows Control Panel.
Some of these agent sites might not have access to the warehouse, so verify that the site can connect to the warehouse before you select the site.
Scroll to the right to view additional column information about the agent, such as host name and operating system type.
Scroll to the right to view additional column information about the agent site, such as host name and operating system type.
If your warehouse is no longer available at the agent site, select the agent site and click <. The agent site moves from the Selected agent site list to the Available agent site list.
Use the Retry page of the Warehouse Target notebook to specify an interval after which the Data Warehouse Center will retry a data extract if the first extract fails. A default retry interval is automatically set for each new warehouse target that you define. If you specify a new retry count and interval, it will become the default retry count and interval for any new steps that you create.
The Data Warehouse Center retries data extracts when one of the following problems occurs:
A change is made to a step upon which the step that failed to run is dependent.
The Data Warehouse Center is unable to send a message to the agent daemon. This can occur when you attempt to run a step that uses an agent that is not running.
The Data Warehouse Center is unable to send a message to the agent. This can occur when the wrong host name is specified for the agent or when the connection to the agent is down.
An error occurs while the Data Warehouse Center is receiving the start acknowledgment from the agent.
An error occurs while the Data Warehouse Center is receiving a message from the agent.
There is insufficient page file space for the agent.
The agent site is overloaded.
The Data Warehouse Center also retries data extracts when one of the following return codes is returned:
IWHO7902
IWHO7903
IWHO7904
IWHO7905
IWHO7906
IWHO7907
See the Data Warehouse Center Messages and Reason Codes online book for information on these return codes.
It is recommended that you use the default retry count and interval, but you can modify the retry count and interval to meet your requirements. The retry count and interval must be consistent with the schedule for the step. For example, do not retry every 6 hours a step that is scheduled to run hourly.
Use the Files page to add a flat file definition that you want to include in the warehouse target. You can also list existing flat file definitions, change a file definition, and delete a file definition.
This page is displayed for flat file warehouse targets only.