(Kollol Kumar Misra, Mamta Sharma and Tapan Kumar Ghosh) Starting with IBM Informix 11.70xC2, Informix started supporting the non-root installation feature. This feature, sometimes called private installation, allows Informix to be installed by a user other than root and permits the software to run
Tag: IBM
TechTip: Implement a Rolling Average User-Defined Function in DB2 for i – See more at: http://www.mcpressonline.com/database/techtip-implement-a-rolling-average-user-defined-function-in-db2-for-i.html#sthash.EaN3QCOU.dpuf
(Michael Sansoterra) A friend recently asked me how to convert a particular Oracle query to SQL Server 2005. The query contained a column expression that looked like this (modified and simplified):
DB2 Tips n Tricks Part 4
(Harishkumar Baburao Pathangay) How to move/copy Data without Intermediate Data(DEL/IXF) Files.
Build a Web API to expose Salesforce.com objects
(Katherine Sanders) In this article, API developers can learn how to use IBM WebSphere Cast Iron Web API Services to create a web API that can be invoked to create a contact in the Salesforce.com customer relationship management system. With IBM WebSphere Cast Iron Web API Services, you can assemble
How to find the db2 database create date
(Jack Vamvas) To find the database creation date execute a query on the syscat.tables. Example:
Extended row size support in DB2: Fitting more data into a single row than the page size would typically allow (and sometimes it makes sense, but that is another story – stay tuned for user experience…)
(Henrik Loeser) One of the new features of the new DB2 10.5 release is the support for so-called extended row size. As you might have guessed from the article’s title, you can squeeze a lot of data into a single row now.
DB2 LUW – What is a Page?
(Ember Crooks) The logical view of a database consists of the standard objects in any RDBMS – Tables, Indexes, etc. There are a number of layers of abstraction between this and the physical hardware level, both in the OS and within DB2.
DB2 NoSQL JSON Capabilities, Part 3: Writing applications with the Java API
(Marion Behnen, Henry Chiu, Jyh-Chen Fang, Manish Sehgal and Tony Sun) Rapidly changing application environments require a flexible mechanism to store and communicate data between different application tiers. JSON (Java Script Object Notation) has proven to be a key technology for mobile, interactiv
DB2 database hangs on db2 connect – use db2pd to troubleshoot
(Jack Vamvas) During a DB2 database Physical 2 Virtual (P2V) migration , the systems administrator did not request for the application be shut down. The usual practise for a P2V is to shut down the application and shut down DB2 – then start P2V. This didn’t occur and resulted in a potential corrup
Install Optim Performance Manager
(Thuan Bui) This video outlines the components needed for Optim Performance Manager install, goes through the install , and highlights the best practices for OPM install.