Informix Chat with the Lab -"IBM Informix Enterprise Data Management for the Internet-of-Things" (Mar 25 10:30 CDT)
wilhap 0600007F3T Visits (142)
Informix Chat with the Lab -"IBM Informix Enterprise Data Management for the Internet-of-Things"
Event Date: Mar 25, 2014
Event Time: 10:30 AM - 12:00 PM (Central Time)
Hosted By: Anita McKeithen (IBM)
Presented By: Jerry Keesee - Director, IBM Informix Database Development (IBM), Pradeep Muthalpuredathe - Sr. Manager - CTE Informix Competitive Technical Enablement (IBM)
Why IBM Informix is best suited for the Internet-of-Things. From its embed capabilities with its small footprint and ease of use and administration, to its use in the cloud as a fully operational database with warehouse and analytic capabilities. IBM Informix is a single database that provides solutions from end to end in the Inte
Join the Event
Before you join the event, test your system at:
Join the event at:
If clicking a link above does not work, please copy the entire link and paste it into your Web browser.
Join the Voice Conference
Teleconference Access Number 1:North America dial: USA : 866-803-2143 ;UK 0800-279-3953 ; France : 080-510-0831 ;BANGALORE: 91-80-61275198 ISRAEL : 1-80-9214815 ; ARGENTINA :0800-777-0476 ; AUSTRALIA; 1-800-204-161 ; AUSTRIA :0800-677-989 ;CHI
Teleconference Access Number 2:International dial: BELGIUM 0800-4-8574;BRAZIL 0800
Teleconference ID:032014 (Enter this value when prompted)
For technical questions, contact support at supp
For questions about this event, contact the host at: mcke
JunGuo 270006BN0K Visits (138)
JunGuo 270006BN0K Visits (150)
Resource Info: ODBC DSN configuration with db2cfexp and db2cfimp utilities on Windows Operating System
MaryKKassey 2700055CKK Visits (312)
Export from 64-bit windows - machine 1, import to 64-bit Windows- machine 2:
- db2cfexp with template/backup option on machine1
When using the Configuration Assistant on Windows 64-bit platforms, ODBC Data Sources can be configured only for 64-bit applications.
- db2cli32.exe is part of DB2 64-bit products, it is used to register 32-bit ODBC DSN's on 64-bit Windows.
- 32-bit DB2 products come with only db2cli.exe which is used to register 32-bit ODBC DSN.
KateDawson 060001TQ2C Visits (247)
We did it... we reached a million views! And for that, we want to thank our amazing group of readers who make this blog successful.
Another big thanks goes to our many talented content contributors, who share their product expertise with us through this blog!
But, like all good IBMers, we're always driving to our next milestone and we want to hear from you to help us get there! What would you like to see from this blog? Do you have ideas for topics or technical challenges you'd like us to address? Add a comment to this post and we'll see about getting the posts written for you.
And finally, here are a few links to our most popular posts over time:
Thanks again and happy reading!
P.S. Did you know we are also active on Facebook, Twitter, and in the developerWorks product forums?
wilhap 0600007F3T Visits (186)
At present most of the Informix configuration parameters can be modified dynamically. Typically, users run 'onmode -wf' or 'onmode -wm' command to dynamically change a specific configuration parameter. But there may be a situation when you need to modify multiple parameters at once. For example, you have ten Informix instance and want to tune some of SQL statement cache configuration parameters on all the Informix instances.
Now, you can import a configuration file using onmode command to change multiple configuration parameter at once. Importing a configuration file is often faster and more convenient than changing one configuration parameter at a time. You can use the 'onmode -wi' command to import a file that contains new values for multiple configuration parameters. If the parameters are dynamically tunable, the database server applies the new values. The import operation ignores the configuration parameters in the file that are not dynamically tunable and if the new parameter values same as the existing value.
However, you need to keep a note hare that an import operation changes the values of configuration parameters only in the memory. It does not modify the values in the ONCONFIG file on disk.
Let's take the same example as before, modify some of SQL statement cache configuration parameters using import operation. Currently, you have following settings:
You create a 'onconfig.new' file under '/tmp' directory with following values to modify the configuration parameters:
Next, you run the following command to import configuration values from file named 'onconfig.new' in the the /tmp directory:
The above command generates appropriate messages on screen and the message log. Following is an excerpt of the message log:
You can notice only three out of the five parameters has been changed because either those are not dynamically tunable or using same existing value.
As the 'onmode -wi' command import a configuration file, you can also export configuration parameters from memory to a file using 'onmode -we' command.
-- Thanks Sanjit
wilhap 0600007F3T Visits (173)
The following Informix information centers will be sunset in the near future:
ubektas 27000478GM Visits (323)
InfoSphere® QualityStage® Address Verification Interface (AVI) V10.0 enables you to standardize, verify, correct, and enhance international address information.
IBM® InfoSphere® QualityStage® Address Verification Interface parses, validates, and transliterates address data for over 240 countries or regions from around the world.
ubektas 27000478GM Visits (357)
Do you know that there is a new process for submitting enhancement requests against InfoSphere Information Server ?.
And you no longer need to open a support ticket to accomplish this.
The following URLs contain FAQ and video tutorial on various RFE operations.
JunGuo 270006BN0K Visits (189)
gorddbds 060001JCXS Visits (367)
DB2 LUW is capable of running stored procedures and functions coded in several languages. Among these languages is Java. Since Java stored procedures and functions, (collectively referred to as routines) require a JVM there are some configuration settings that are specific to this type of routine. DB2 comes with a JDK and by default it is this JDK that is used to run Java routines. It is possible to alter DB2 to use another JDK to run Java routines. JDKs that are supported to run routines are documented in the DB2 infocenter for each release.
The Version 10.1 page is located at the following URL.
The JDK DB2 uses is specified by the JDK_PATH dbm cfg variable and by default is set to the instance's JDK location.
The following URL documents this variable for version10.1
In addition to the JDK you can specify how much Java Heap each JVM will use. If you believe your routine workload may require more or less Java Heap than the default, you can modify the amount of heap allocated by changing the dbm cfg variable JAVA_HEAP_SZ to the desired value.
The following URL documents the JAVA_HEAP_SZ variable for version10.1
The JVM for DB2 Java routines is created per process. Java routines that have been created as “threadsafe” can run with other routines in a single process and use a single JVM. If there is a Java routine that is expected to use a large amount of resources. You may wish to create this routines as “not threadsafe”. This will cause it to be run in its own process and have all the resources of the JVM for its use.
The following URLs document the Create Procedure and Create function statements for 10.1
Create Scalar Function
Create Table Function
gorddbds 060001JCXS Visits (321)
DB2 LUW has two basic edition classifications Clients and Servers. Clients include drivers and full DB2 clients. Servers include both DB2 and DB2 Connect servers. DB2 Clients do not require a license to use when connecting to DB2 LUW servers. DB2 servers include DB2 client code and if no permanent license is installed the server functionality will be unavailable once the trial period expires but the client code may still be used. To license purchased DB2 LUW server products two licenses will need to be installed.
One license referred to as the base license is shipped with the product and identifies the specific DB2 product. This license does not enable server or DB2 Connect functionality. DB2 LUW editions will automatically enter try and buy mode if no product licenses are detected and the base license is installed. This mode will allow the DB2 server editions to run for 90 days after which time the trial will end and only client functionality will be available. The base license is usually automatically installed with DB2.
The second license file is the permanent license and represents the license agreement that is purchased with the product. Since DB2 LUW can be licensed in more than one way there is more than one type of permanent license file. Each license type uses a different permanent license file. The names of the license files and what licenses they apply to are documented at the following infocenter URLs.
Once a permanent license is installed, the db2licm -l command will return Permanent for the Expiry date. If any value other than permanent returns there is no permanent license installed.
Permanent licenses are available on Passport Advantage. The following URL documents locating and downloading a permanent license.
Swati Thorve 270004FTYS Visits (308)
Recently I came across a PMR, customer was using sysp
We cannot delete one policy unless delete all of them:
db2 "call sysi
and then install the default policy:
db2 "call sysi
More details on sysinstallobjects objects here.
Thank you for reading!
Resource Info: Memory Limitations for DB2 Workgroup Server Restricted License for different versions
MaryKKassey 2700055CKK Visits (298)
Do you know the instance memory limitations for DB2 Workgroup Server Restricted License for different DB2 versions?
First of all, I would like to explain what DB2 Workgroup Server Edition (WSE) Restricted License (db2wse_o.lic) means. Its nothing but that your DB2 database product was obtained as part of another IBM® product. In this case, the license terms of the bundling product takes precedence over the usual DB2 Version Workgroup Server Edition license terms.
The DB2 license command 'db2licm -l' will display the following output:
JunGuo 270006BN0K Visits (183)