© Copyright IBM Corporation
2004
September 2004
Setting up the XML Extender administration wizard
Web Services Development Environment: alternate document access definition (DAD) editing tool
What's new in XML Extender administration wizard with version dated 08-18-04?
The administration wizard helps you manage your database and tables for use with XML files. The wizard helps you complete the following tasks:
The following instructions will guide you through setting up your system to use the wizard.
This document assumes that you have downloaded the wizard package because any of the following conditions apply to you:
To set up and start the XML Extender administration wizard:
If you are using an operating system in which Java support is not provided by DB2 UDB, you must install the JDK or JRE yourself. Use the link above to the DB2 Java Web site to find download packages for the various levels of Java that have been tested with DB2 UDB. You can also choose to install another version of the JDK or JRE even if you have the DB2-provided versions installed.
dxxadmin
Jdbc:db2:ISC710P1
where ISC710P1 is the alias database name that is cataloged on the local system.
Tip: If you want to specify a database name instead of a JDBC URL, you must first run the following commands to allow the local DB2 UDB system to forward the SQL requests to the remote server:
-- Remove prior catalog entries db2 uncatalog node ISC710P1 db2 uncatalog database db710p1 db2 uncatalog dcs database ISC710P1 -- Add TCP/IP node entry to the node directory to access the remote node db2 catalog tcpip node isc710p1 remote isc710p1.stl.ibm.com server 446 -- Store remote database location information in the local database directory db2 catalog database isc710p1 as db710p1 at node isc710p1 authentication dcs -- Store remote database information in the Database Connection Services (DCS) directory db2 catalog dcs database isc710p1 as stlec1
DB710P1 is the database name that is successfully cataloged into the client system. Then in the Logon window, you can specify DB710P1 as the database name that you want to access.
COM.ibm.db2.jdbc.app.DB2Driver
The XML Extender administration launchpad is started when you complete the logon window. You can use this launchpad to do any of the following tasks:
Software | PATH value |
---|---|
Java binary files | Depends on the Java package that you use:
|
XML Extender administration directory | Version 7:
|
Table 2 describes the directories and requirements for the
CLASSPATH.
Software | CLASSPATH value |
---|---|
XML Extender jar files (V7 only):
|
|
XML Extender jar files (V8 only):
|
|
Java class libraries |
|
Swingall.jar file |
|
JDBC: db2java.zip |
|
See the DB2 UDB XML Extender Administration and Programming to learn how to start the wizard and connect to the database. OS/400 users, see Setting up the wizard on OS/400 to learn how to configure and start the wizard when connecting to OS/400 systems.
The set up for the administration wizard has some minor differences from the other operating systems.
Before you run the wizard, you must configure the CLASSPATH statement on your workstation system. Setting up the adminstration wizard on all operating systems except OS/400 describes the general steps. The exception to this process for OS/400 is the JDBC driver path, which is not provided with DB2 UDB for iSeries.
To set up, download and install the JDBC driver, and add the file name to the CLASSPATH. Additionally, to connect to an OS/400 database system, you must provide connectivity information in a slightly different format from OS/390, UNIX, or Windows. The follow sections describe how to install and configure the JDBC driver, and how to enter the initial settings for the wizard.
The JDBC driver for AS/400 is delivered in the AS/400 Toolbox for Java class files. To use it, you must copy the toolbox on your workstation.
Copying the AS/400 Toolbox for Java class files on your workstation:
You can get server updates on your workstation by using the AS400ToolboxInstaller
class or other means, such as ftp. To use the AS400TolboxInstaller class,
complete the following steps:
To use an alternative method, complete the following steps:
On Windows, you can start the wizard by creating a shortcut and clicking on the icon. On Windows or UNIX, you can also modify the dxxadmin400.cmd file and run the cmd file to start the wizard. In both cases, you enter connectivity values. The following sections describe the start up values required for using the wizard.
When you start the XML Extender administration wizard, the Logon window opens, and requests information required to connect to a DB2 database.
To connect to the database, enter the following values on the first screen:
jdbc:as400://host_name/database_nameWhere database_name is the database to which you are connecting and storing XML documents.
For example:
jdbc:as400://host1.mycompany.com/mydb
com.ibm.as400.access.AS400JDBCDriver
Customize the dxxadmin400.cmd file to save your startup values and start the wizard. To customize the file, locate the file in the directory with the wizard files and open it in a text editor. Replace the existing text with the following value:
java -classpath "dxxadmin.jar;xml4j.jar;jt400.jar" com.ibm.dxx.admin.Admin url=jdbc:
as400://host_name/database_name driver=com.ibm.as400.access.AS400JDBCDriver
When you start the wizard, these values are entered in the Logon window, and you can connect to the database.
WebSphere Studio provides a tool that can create document access definitions (DAD) for XML Extender. For more information, see Exploring the RDB to XML Mapping Editor.
This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service.
IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:
IBM Director of LicensingFor license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:
IBM World Trade Asia CorporationThe following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.
This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.
Licensees of this program who want to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact:
IBM CorporationSuch information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.
The licensed program described in this information and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us.
Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.
All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.
COPYRIGHT LICENSE:
This information contains sample application programs in source language, which illustrates programming techniques on various platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs.
The following terms are trademarks of the International Business Machines Corporation in the United States, or other countries, or both:
DB2
DB2 UDB
DB2 Universal Database
iSeries
OS/390
OS/400
z/OS
Java and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.
UNIX is a registered trademark in the United States, other countries, or both and is licensed exclusively through X/Open Company Limited.
Other company, product, and service names may be trademarks or service marks of others.