CONNECT and BIND: Finally, connect to the target host server and bind the utilities and applications to the server using commands similar to the following in the command line processor:

connect to MVSIPDB1 user USERID using PASSWORD bind path/bnd/@ddcsmvs.lst blocking all

sqlerror continue blocking all grant public disconnect all

where path corresponds to the DB2PATH registry value.

These commands are described in detail in the Command Reference.

Preparing DB2 Universal Database for AS/400 for DB2 Connect

DB2 Connect gives applications on remote systems access to data in your DB2 Universal Database for AS/400 system. In order to set up the connection, the person installing DB2 Connect needs the following information:

__ 1. The local network name. You can get this information by entering

DSPNETA.

__ 2. The local adapter address. You can get this information by entering WRKLIND (*trlan).

__ 3. The mode name. You can get a list of mode names by entering WRKMODD. If the mode IBMRDB has been de®ned on your AS/400 system, you should use it.

__ 4. The local control point name. You can get this information by entering

DSPNETA.

__ 5. The remote transaction program name. The default is X©07©6DB (X©07F6C4C2©). The default is always used by DB2 Universal Database for AS/400. If entering a hexadecimal number is not convenient, an alias is QCNTEDDM.

__ 6. The relational database name. You can get this information by entering DSPRDBDIRE. This will display a list. The line containing *LOCAL in

the Remote Location column identi®es the RDBNAME which must be de®ned to the client. If there is no *LOCAL entry, you can add one, or use the system name obtained from the DSPNETA command on the server.

Here is an example screen:

52Quick Beginnings

Page 63 Page 65
Page 64
Image 64
IBM GC09-2830-00 manual Preparing DB2 Universal Database for AS/400 for DB2 Connect, Dspneta
Page 63 Page 65

GC09-2830-00 specifications

The IBM GC09-2830-00 is a crucial technical document that details the features, technologies, and operational characteristics of the IBM Enterprise Storage System. This guide is essential for IT professionals, data engineers, and system administrators who work with IBM storage solutions.

One of the main features of the IBM GC09-2830-00 is its focus on providing a comprehensive overview of the IBM storage system's architecture. It highlights the seamless integration of various storage technologies, including the IBM Spectrum Storage Suite, which supports a range of deployment models from on-premises to hybrid cloud environments.

The document outlines the storage system's capabilities, such as high availability, which ensures that data is accessible at all times. This feature is essential for businesses that rely on continuous operation and minimal downtime. The IBM GC09-2830-00 also emphasizes the importance of scalability, allowing organizations to adjust their storage solutions as their data needs grow.

Another critical aspect covered in the GC09-2830-00 is data protection and management. The document details the robust security features inherent in the IBM storage environment, including encryption, access control, and comprehensive data backup solutions. These characteristics are vital in today’s era of rising cybersecurity threats.

In terms of performance, the document illustrates the efficient data handling capabilities of the IBM storage system. It incorporates advanced caching and tiering technologies that optimize storage resources, improving response times for applications and reducing latency.

The IBM GC09-2830-00 also discusses the user-friendly management interfaces that simplify the administration of storage resources. The integration of artificial intelligence and machine learning capabilities further enhances system management, providing predictive analytics and insights to help admins address potential issues before they impact operations.

Finally, the document emphasizes IBM's commitment to sustainability, outlining how its storage solutions minimize energy consumption and promote efficient resource usage. This characteristic aligns with the growing demand for environmentally responsible technology solutions.

In summary, the IBM GC09-2830-00 is a pivotal resource for understanding the powerful features and technologies of IBM's Enterprise Storage System, equipping users with the knowledge to leverage these tools effectively in their data management strategies.
Top Page Image Contents