database is the DB2 location name that is defined during installation. All
characters in this value must be uppercase characters. You can determine
the location name by executing the following SQL statement on the server:
SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1;
-user
Specifes the user ID under which DB2LobTableCreator is to run. This user
must have authority to create tables in the DSNATPDB database.
-password
Specifes the password for the user ID.
-help
Specifies that the DB2LobTableCreator utility describes each of the options that
it supports. If any other options are specified with -help, they are ignored.
Related tasks
“Installing the z/OS Application Connectivity to DB2 for z/OS feature” on
page 435
Chapter 9, “Migrating from the JDBC/SQLJ Driver for OS/390 and z/OS to the
IBM Data Server Driver for JDBC and SQLJ,” on page 439
“Upgrading the IBM Data Server Driver for JDBC and SQLJ to a new version”
on page 434
Verify the installation of the IBM Data Server Driver for JDBC
and SQLJ
To verify the installation of the IBM Data Server Driver for JDBC and SQLJ,
compile and run a simple JDBC application.
For example, you can compile and run this program to verify your installation:
/**
* File: TestJDBCSelect.java
*
* Purpose: Verify IBM Data Server Driver for JDBC and SQLJ installation.
* This program uses IBM Data Server Driver for JDBC and SQLJ
* type 2 connectivity on DB2 for z/OS.
*
* Authorization: This program requires SELECT authority on
* DB2 catalog table SYSIBM.SYSTABLES.
*
* Flow:
* - Load the IBM Data Server Driver for JDBC and SQLJ.
* - Get the driver version and display it.
* - Establish a connection to the local DB2 for z/OS server.
* - Get the DB2 version and display it.
* - Execute a query against SYSIBM.SYSTABLES.
* - Clean up by closing all open objects.
*/
import java.sql.*;
public class TestJDBCSelect
{
public static void main(String[] args)
{
try
{
// Load the driver and get the version
System.out.println("\nLoading IBM Data Server Driver for JDBC and SQLJ");
Class.forName("com.ibm.db2.jcc.DB2Driver");
System.out.println(" Successful load. Driver version: " +
432 Application Programming Guide and Reference for Java
™
To Next Page
Loading...
Need help?
General