"bind @db2ubind.lst messages bind.msg grant public" "bind @db2cli.lst messages clibind.msg grant public"

In this example, bind.msg and clibind.msg are the output message ®les, and EXECUTE and BINDADD privileges are granted to public.

Step 4. Reset the connection to the database by entering the following command:

connect reset

For more information on the bind command, refer to the Command

Reference.

Notes:

1.The db2ubind.lst ®le contains the list of bind (.bnd) ®les required to create the packages for the database utilities. The db2cli.lst ®le contains the list of bind (.bnd) ®les required to create packages for the DB2 CLI and the DB2 ODBC driver.

2.Binding may take a few minutes to complete.

3.If you have BINDADD authority, the ®rst time you use the DB2 CLI or ODBC driver, the DB2 CLI packages will be bound automatically.

If the applications that you are using require binding to the database, you can use the Client Con®guration Assistant's Bind facility, or the command line processor, to perform the bind action.

Running CLI/ODBC Programs

The DB2 Call Level Interface (CLI) run-time environment and the DB2 CLI/ODBC driver are included with DB2 clients as optional components during install.

This support enables applications developed using ODBC and DB2 CLI APIs to work with any DB2 server. DB2 CLI application development support is provided by the DB2 Software Developer's Kit (DB2 SDK) which is packaged with your DB2 server.

Before DB2 CLI or ODBC applications can access DB2, the DB2 CLI packages must be bound on the server. Although this will occur automatically on the ®rst connection if the user has the required authority to bind the packages, it is recommended that the administrator do this ®rst with each version of the client on each platform that will access the server. See ªBinding Database Utilitiesº on page 119 for speci®c details.

Chapter 10. Running Your Own Applications 121

Page 133
Image 133
IBM GC09-2830-00 manual Running CLI/ODBC Programs, Reference

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.