Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\db2.09.03.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Binding</title> <link rel="StyleSheet" href="css/db2.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="db2.09.01.html#106225">5 The DB2 Wire Protocol Driver</a> : Binding</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="106225">Binding</a></div> <div class="Body"><a name="528341">The driver does not work properly unless bind packages exist on every server to which you </a>intend to connect.</div> <div class="Body"><a name="528342">IMPORTANT: You must have the appropriate privileges for the driver to create and bind </a>packages with your user ID. These privileges are:</div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="512229">BINDADD for binding packages</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="512230">CREATEIN on the collection specified by the Package Collection option</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="512506">GRANT EXECUTE on the PUBLIC group for executing the packages</a></div> </td> </tr> </table> </div> <div class="Body"><a name="512507">These are typically the permissions of a Database Administrator (DBA). If you do not have </a>these privileges, someone who has a user ID with DBA privileges needs to create packages by connecting with the driver. </div> <div class="Body"><a name="106228">When connecting for the first time, the driver determines whether bind packages exist on </a>the server. If packages do not exist, the driver creates them automatically using driver data source default values.</div> <div class="Body"><a name="106229">NOTE: The initial driver connection to a particular server may take a few minutes because </a>of the number and size of the packages that must be created on the server. Subsequent connections do not incur this delay.</div> <div class="Body"><a name="106231">If you change default values in a data source before connecting with the driver for the first </a>time, the new defaults are used when creating the packages. If you want to change these values after the packages have been created, you can create or modify packages from the Modify Bindings tab of the Setup dialog. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#106667', '');">Step 6</a></span> under <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#106331', '');">â??Configuring and Connecting to Data Sourcesâ??</a></span> for details.</div> <div class="Body"><a name="106242">On UNIX and Linux, you can also create or modify packages through a special bind utility. </a>Depending on the platform of the DB2 server, the attribute values that must be set in the data source to bind packages are:</div> <div class="Body"><span class="Action_bold"><a name="106243">Linux/UNIX/Windows DB2 Servers</a></span>: IpAddress, Database, TcpPort</div> <div class="Body"><span class="Action_bold"><a name="106244">z/OS and iSeries DB2 Servers</a></span>: IpAddress, Location, TcpPort</div> <div class="Body"><a name="449210">Other attribute values also affect binding. See the note for </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#106667', '');">Step 6</a></span> under <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#106331', '');">â??Configuring and Connecting to Data Sourcesâ??</a></span> for details. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.05.html#282192', '');">â??Connection Option Descriptionsâ??</a></span><span class="Cross_ref_"> </span>for a description of these connection string attributes and their values. You must use the default values or specify new ones for these attributes in the DB2 data source section of the odbc.ini file before binding. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.1.html#116869', '');">Chapter 4 â??Configuring the Product on UNIX/Linuxâ??</a></span> for details on creating the DB2 data source.</div> <div class="Body"><a name="106279">The bind utility is located in </a><span class="Emphasis">installation_directory</span>/bin. After specifying the appropriate connection string attribute values in the odbc.ini file, create or modify packages by entering the command:</div> <div class="syntax_first"><a name="106280">bindxx </a><span class="EquationVariables">dsn</span> </div> <div class="Body"><a name="106281">where </a><span class="EquationVariables">xx</span> is the driver level number in the driver file name and <span class="EquationVariables">dsn</span> is the ODBC data source name in the odbc.ini file. For example:</div> <div class="syntax_first"><a name="515160">bind26 DB2 Wire Protocol</a></div> <div class="Body"><a name="515161">You are prompted for a user ID and password if they are not stored in the data source. If </a>packages are created and bound successfully, a message indicating success appears. If there are problems connecting or creating the packages, an appropriate error message appears.</div> <div class="head_2"><a name="106282">Creating DB2 Packages Using List Files</a></div> <div class="Body"><a name="106283">You can bind the following list files on your database server to create DB2 packages:</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="106284">DDODBC_LUW.lst (DB2 for Linux/UNIX/Windows)</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="106285">DDODBC_MVS.lst (DB2 for z/OS)</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="523830">DDODBC_400.lst (DB2 for iSeries)</a></div> </td> </tr> </table> </div> <div class="Body"><a name="106288">The list files are located in the \bind\LUW, \bind\zOS, and \bind\iSeries directories, </a>respectively, in your DataDirect Connect Series <span class="forbody">for</span> <span class="APIbody">ODBC</span> installation directory. When you bind the list files, if any DataDirect DB2 packages exist, they will be replaced by the new packages. The list files create DB2 packages that, by default, contain 200 dynamic sections and are created in the NULLID collection.</div> <div class="hanging_label_head"><a name="106289">To create DB2 packages by binding list files:</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="106290">Copy the appropriate list (*.lst) file and bind (*.bnd) files located in the /bind directory to </a>a directory on the database server.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="106291">From the database server directory where you placed the list and bind files, start the </a>DB2 command-line utility. Use the utility to connect to the database where you want to bind the packages. Connect using the following command:</div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="106292">connect to </a><span class="EquationVariables">database_name</span> user <span class="EquationVariables">authorization_name</span> using <span class="EquationVariables">password</span></div> <div class="Body_Indent"><a name="106293">where:</a></div> <div class="Body_Indent"><span class="EquationVariables"><a name="106294">database_name</a></span> is the name of the database to which you are connecting.</div> <div class="Body_Indent"><span class="EquationVariables"><a name="106295">authorization_name</a></span> is the name of the user you are authenticating to the server.</div> <div class="Body_Indent"><span class="EquationVariables"><a name="106296">password</a></span> is the userâ??s password.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="106297">Execute the DB2 bind command:</a></div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="106298">bind @</a><span class="EquationVariables">list_file</span> grant public</div> <div class="Body_Indent"><a name="506089">where </a><span class="EquationVariables">list_file</span> is the name of the list file you want to bind.</div> <div class="head_2"><a name="523710">Creating DB2 Packages Manually</a></div> <div class="Body"><a name="523746">On z/OS and iSeries servers, you can bind files manually to create DB2 packages. Refer to </a>one of the following instruction files, as appropriate:</div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="523747">CFODBC ZOS MANUAL PACKAGE CREATION INSTRUCTIONS.TXT (DB2 for z/OS)</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="523748">CFODBC AS400 MANUAL PACKAGE CREATION INSTRUCTIONS.TXT (DB2 for </a>iSeries)</div> </td> </tr> </table> </div> <div class="Body"><a name="523716">These instruction files are located in the bind\ZOS and \bind\ISERIES directories, </a>respectively, in your DataDirect Connect Series <span class="forbody">for</span> <span class="APIbody">ODBC</span> installation directory.</div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de