Db2 Express C Db2 Install Problem
Install the DB2 Express-C database. Because no standalone database is installed on the OPL development machine by default. Returning the error.
IBM® DB2® Universal Database TM Express Edition (DB2 UDB Express) is the newest member of the IBM DB2 family. It is designed, priced, and marketed specifically to help small and medium businesses integrate and manage business processes. DB2 UDB Express offers:. Transparent installation with your application. Enhanced autonomic manageability features. Lower total cost of ownership.
Db2 Express C Tutorial
This article describes the complete DB2 response file installation process on Microsoft® Windows® and Linux platforms, which are the platforms on which DB2 UDB Express is offered. Unlike standard DB2 setup utilities, a DB2 response file installation lets you install DB2 without interactive user input. This is useful not only for large-scale deployments of DB2, but also for embedding the DB2 installation process transparently inside your own installation program. The response file installation is one of the reasons why DB2 provides a complete solution for your embedded database needs. The DB2 response file installation is a background installation process that you can embed into an existing installation program, and it is transparent to end users.
The installation is performed by DB2 setup utilities with user-generated response files. The response files are ASCII text files that contain setup and configuration information, which can be generated either with DB2 utilities or by manual editing. This article covers response file generation, response file installation, database setup and de-installation in detail, along with special considerations for embedding the DB2 installation process into your own application installation program. Generating response files The first step of the response file installation process is to generate a response file. When installing DB2 using the interactive setup utility, you are prompted to make installation choices and provide necessary configuration data before installation takes place.
Response files simply contain these installation choices and configuration data, which are already prepared for embedded use. There are three methods to generate the responses files:. Using the DB2 Setup wizard. Using the DB2 response file generator utility (Windows only). Generating the response file manually The response files are ASCII text files. Is a sample of a partial response file.
Sample of a partial response file PROD= UDBEXPRESSEDITION LICAGREEMENT=ACCEPT FILE=C: SQLLIB INSTALLTYPE=CUSTOM COMP=DEVELOPMENTCENTER. COMP=CONTROLCENTER COMP=CLIENTTOOLS COMP=COMMANDCENTER. COMP=TCPIPDB2CLIENTSUPPORT COMP=TCPIPDB2LISTENERSUPPORT LANG=EN DASCONTACTLIST=LOCAL INSTANCE=DB2 DB2.NAME=DB2 DEFAULTINSTANCE=DB2 DB2.SVCENAME=db2cDB2 DB2.DB2COMM=TCPIP DB2.PORTNUMBER=50000 DB2.FEDERATED=YES. You can find a complete sample response file on your DB2 installation CD in the following locations:. For Linux, it is located at /db2/linux/samples, where represents the location of the DB2 installable image. For Microsoft Windows, it is located at x: db2 windows samples, where x: represents the CD-ROM drive. The response file is named db2exp.rsp for DB2 UDB Express.
For a brief description of some of the DB2 response file keywords, see. Using the DB2 Setup wizard The DB2 Setup wizard is the GUI installation utility available on both Microsoft Windows and Linux platforms. It is the program that you normally run interactively when you install DB2. Instead of, or in addition to, installing the product, you can also save all of your choices in the response file for later use. To save your choices in a response file, you need to choose the custom installation type shown in.
Choosing the customized installation type. If you have never used the DB2 Setup wizard before, you can find it at the following locations:. For Microsoft Windows, it is named setup.exe and is located in the root directory of the installation CD. For Linux, it is named db2setup and is located in the root directory of the installation CD or image. When the DB2 Setup wizard process is complete, save the DB2 response file that was generated for you.
You can choose the path and the file name for the generated response file. You must manually modify the generated response files to accept the license agreement before they are useable. Using the DB2 response file generator The DB2 response file generator utility is available on Windows platforms only. The idea is to create a master installation first and then use the response file generator to create a response file that can install the same DB2 components as the master installation. The utility can also generate instance profiles to create and configure the instances.
Shows the syntax for the response file generator utility, db2rspgn. Syntax for db2rspgn utility. By default, db2rspgn generates profiles for all instances on the master installation along with the response file. You can choose not to create profiles for the Data Links File Manager (DLFM) instance and control server instance by using the -nodflm and -nocltsv options, respectively.
You can also specify the individual instances for profile creation. The profile files are put in the same directory as the response file. You must do some minor editing on the generated response files before they are useable:. Manually modify the file to accept the license agreement. Enter the user ID and password for the new systems. Generating response files manually Because the response files are ASCII text files, you can create them manually. You can choose to modify the sample response files provided with the DB2 image or you can re-create them yourself.
Db2 Express C Installation
This method requires a solid understanding of the response file structure and keywords. Fortunately, the sample response files are well commented and self-explanatory. Here are brief descriptions of some of the keywords that you specify in the response file. PROD Specifies the product that you want to install. UDBEXPRESSEDITION for DB2 UDB Express. ADMINISTRATIONCLIENT for the DB2 Administration Client. APPLICATIONDEVELOPMENTCLIENT for the DB2 Application Development Client.
RUNTIMECLIENT for the DB2 Run-Time Client. FILE Specifies the destination directory for a DB2 product (for Windows only). INSTALLTYPE Specifies the type of installation: COMPACT, TYPICAL or CUSTOM.
COMP Specifies the components that you want to install. This keyword is ignored unless your INSTALLTYPE is CUSTOM. LANG Specifies a language support you want to install. REBOOT Specifies whether to restart the Windows system when the installation has completed. KILLPROCESSES Specifies if the installation will terminate the currently running DB2 processes without prompt (for Windows only). Other options include those for:. DB2 Administration Server settings.
Instance settings. Database settings For a complete list of keywords, detailed description and usage information, see the sample response file on your installation CD and the DB2 UDB Express documentation.
Using response files for unattended installation This section describes:. The installation. the installation. the installation The installation process After you generate the response files, installation is straightforward.
Use the same executables that you used in the GUI installation. However, instead of typing the command only at the prompt or double-clicking setup.exe, you must provide the proper response file name. You can also specify other options such as log file path and name.
Is the syntax for the setup utility on Windows. Only the response file name with the full path is mandatory for a response file installation. Syntax for setup utility on Windows platforms setup /f /I /l /u /t /? - generates this usage message /f - forces any db2 processes to stop before installing /i - two letter code for the preferred language /l - full path and name of the log file /u - full path and name of the response file /t - creates a file with install trace information On Linux, use the db2setup syntax shown in. Syntax for db2setup on Linux.
Is anyone else working on DB2 Express-C on Windows? I'm working on a first install of a Windows-platform instance of DB2 Express-C V9.5 on a Win2003 Server. Mechanics of the install was completed by someone else and turned over to me. When attempting to perform an initial SQL, not against the SAMPLE database (which works fine), I get an error box which contains:. IBMCLI Driver SQL1337N The service 'herb' was not found. Explanation: The system cannot resolve the port number associated with the service-name.
Possible causes are:. An incorrect service-name value was specified when the TCP/IP node was cataloged. The correct service-name was specified, but was not defined in the client's services file. Federated system users: this situation can also be detected by the data source.
User response: Make sure that the service-name specified when cataloging the TCP/IP node is a correct name, and that it is defined in the local services file. Federated system users must also ensure that the name is defined in the services file at the data source. There are two relevant notes on the Net, one at IBM, which recommends making sure that two registry entries are correct (I did that, and they were already set to the values IBM specified), and the other on news:comp.databases.ibm-db2 on 2006-08-22, which said that one should try certain commands:.
I have been using Cardfile.exe from an ancient version of Windows through XP and up until Windows 7.can't seem to get it to work in Win 7.any ideas??? Free Ware Cardfile: Cardfile. Reminiscent of Microsoft Cardfile with more features. Also a replacement for MS Cardfile A powerful tool for storing and finding. Ms cardfile replacement. Mar 19, 2017 What is a good Application that one can recommend to use Microsoft CARDFILE 3.1 to convert to, and use in Windows 7. Introduction For database applications there seems to be always a very high learning curve before you are able to use it for your purposes. With much less effort card.
Can u paste us these commands? Are u trying this connect statement from CLIENT?
If yes db2 list node directory db2 list db directory Looks like you have CATALOGED this node using the SVCENAME instead of PORT number. Db2 'catalog tcpip node xxx remote server ' db2 'catalog database at node xxx' Then try again. Shashi Mannepalli.
My problem is that I don't know what values to present for xxx and portnumber, and was hoping someone could show me where to go to determine them. New User of DB2 Express-C Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above.
If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City. IDUG 08 Warsaw, Poland. 13-17 October 2008. The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at under the Listserv tab.
While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services. Post the output of the following commands from the remote machine. db2 list node directory db2 list db directory post the result of the following command on the machine with the database db2 get dbm cfg And we'll help you get configured. You'll also have some kind of /etc/services file that has all the service definitions (and the tcpip ports they relate to) in it. It might be needed as well.
On Thu, 9/4/08, Sevetson, Phil wrote: From: Sevetson, Phil Subject: DB2-L DB2V9 Express-C Win: Install Problem with Service (SQL1337N) To: login to unmask email Date: Thursday, September 4, 2008, 9:30 AM Hi, all. Is anyone else working on DB2 Express-C on Windows? I'm working on a first install of a Windows-platform instance of DB2 Express-C V9.5 on a Win2003 Server. Mechanics of the install was completed by someone else and turned over to me.
When attempting to perform an initial SQL, not against the SAMPLE database (which works fine), I get an error box which contains:. IBMCLI Driver SQL1337N The service 'herb' was not found. Explanation: The system cannot resolve the port number associated with the service-name. Possible causes are:. An incorrect service-name value was specified when the TCP/IP node was cataloged.
The correct service-name was specified, but was not defined in the client's services file. Federated system users: this situation can also be detected by the data source. User response: Make sure that the service-name specified when cataloging the TCP/IP node is a correct name, and that it is defined in the local services file. Federated system users must also ensure that the name is defined in the services file at the data source. There are two relevant notes on the Net, one at IBM, which recommends making sure that two registry entries are correct (I did that, and they were already set to the values IBM specified), and the other on news:comp.databases.ibm-db2 on 2006-08-22, which said that one should try certain commands:. Can u paste us these commands? Are u trying this connect statement from CLIENT?
If yes db2 list node directory db2 list db directory Looks like you have CATALOGED this node using the SVCENAME instead of PORT number. db2 'catalog tcpip node xxx remote server ' db2 'catalog database at node xxx' Then try again. Shashi Mannepalli. My problem is that I don't know what values to present for xxx and portnumber, and was hoping someone could show me where to go to determine them. -Phil S. New User of DB2 Express-C Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above.
If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipientyou are hereby notified that you have received this communication in error and that any review, disclosuredissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
IDUG 08 Warsaw, Poland. 13-17 October 2008. The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Placesee the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUGavailable at no cost, click on Member Services at. IDUG 08 Warsaw, Poland.
13-17 October 2008. The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services. You need to find out what port number is for the instance that the database is a member of is.
Generally this is port 50000 if there is only a single instance on that database server, and is incremented from there. It is not.required. to be 50000, however, if whoever set up the server chose a port other than the default. Of course this is assuming you are connecting to a server on Linux, UNIX or Windows.
For z/OS I don't know, but your DBA should. Frank - Frank Swarbrick Senior Systems Analyst - Mainframe Applications Development FirstBank Data Corporation - Lakewood, CO (303) 235-1403 On 9/4/2008 at 10:30 AM, in message, 'Sevetson, Phil' wrote: Hi, all.
Is anyone else working on DB2 Express-C on Windows? I'm working on a first install of a Windows-platform instance of DB2 Express-C V9.5 on a Win2003 Server. Mechanics of the install was completed by someone else and turned over to me.
When attempting to perform an initial SQL, not against the SAMPLE database (which works fine), I get an error box which contains:. IBMCLI Driver SQL1337N The service 'herb' was not found. There are two relevant notes on the Net, one at IBM, which recommends making sure that two registry entries are correct (I did that, and they were already set to the values IBM specified), and the other on news:comp.databases.ibm-db2 on 2006-08-22, which said that one should try certain commands:. Can u paste us these commands? Are u trying this connect statement from CLIENT? If yes db2 list node directory db2 list db directory Looks like you have CATALOGED this node using the SVCENAME instead of PORT number. db2 'catalog tcpip node xxx remote server ' db2 'catalog database at node xxx' Then try again.
The information contained in this electronic communication and any document attached hereto or transmitted herewith is confidential and intended for the exclusive use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any examination, use, dissemination, distribution or copying of this communication or any part thereof is strictly prohibited. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy this communication. IDUG 08 Warsaw, Poland.
13-17 October 2008. The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at under the Listserv tab.
While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services. Phil- This assumes that database db2tstmg is not on an AS400 or mainframe- Try this on the client machine: db2 uncatalog db db2tstmg db2 uncatalog node NDE3E48B (get rid of the old entries) catalog tcpip node nde3e48b remote psrat02 server 50000 (you may need to fully qualify the psrat02 mchine name with it's full domain name) catalog database db2tstmg at node nde3e48b Now, on the machine hosting DB2.
Db2 update dbm cfg using SVCENAME 50000 db2stop db2start This resets the port from a name to a port number, and 50000 is the default. If the host is an AS400/Iseries or a mainframe there are additional commands. Of course I haven't tested this, so good luck, and feel free to contact me offline if this gets messy. I'm not sure it's a good idea to recommend that he update the SVCENAME for the server. If others are already connecting to it on that port then they will no longer be able to (until those clients are updated in the same manner). I recommend he do. Db2 get database manager configuration.on the server.
He'll then probably see something like this: TCP/IP Service name (SVCENAME) = db2cDB2 or TCP/IP Service name (SVCENAME) = 30280 If it's showing a name, like db2cDB2, then look at the following file: C: WINDOWS system32 drivers etc In it there should be an entry such as: db2cDB2 50000/tcp He can then do much like you say: db2 uncatalog db db2tstmg db2 uncatalog node NDE3E48B db2 catalog tcpip node nde3e48b remote psrat02 server 50000 or db2 catalog tcpip node nde3e48b remote psrat02 server db2cDB2 (This latter one will definitely work if it's on the same machine. On another machine you'd have to add the 'db2cDB2 50000/tcp' entry to the services file, if it's not already present. Or just use the port number directly, as in the first example. It's a totally new instance, not yet being used - this is the initial install and we can't get it to come up for the first time. So your concern is not overriding. Tim's suggestion didn't work anyway. The DB2STOP went fine but the DB2START didn't fly.
Don't know why.