IDS 11.5 Addresses Growing Global Data Access

IBM (NYSE: IBM) today unveiled a new version of its Informix Dynamic Server (IDS) software designed to help companies better manage and utilize the deluge of data generated from global operations while increasing effectiveness and reducing data management costs by one-third.
The new IDS 11.5, code-named “Cheetah 2,” is tuned to enable customers to enhance business [...]

Read Full Post »

To truncate DB2 Table

DB2 Truncate is not as straight forward as Oracle Truncate. If in Oracle you can use “truncate table “…  You may use the below command to truncate table in db2.
alter table schema.table_name activate not logged initially with empty table

Read Full Post »

IBM Database Business Keeps Growing

IBM officials said the company’s database business, bolstered by last year’s releases of DB2 9.5 and IDS 11, enjoyed a solid first quarter of 2008.
With all the talk surrounding IBM’s successful first quarter for 2008, the company’s data server business could get lost in the shuffle. 
But the release of Big Blue’s DB2 9.5 database is [...]

Read Full Post »

SQL Doesn’t Like Logical Files

Today’s tip: Don’t put DDS-defined logical file names in your SQL statements.
To understand why, let me give you a little background. When you execute an SQL command, the system determines the best way to carry out your request. That is, you concentrate on the task that needs to be done, and the system figures out [...]

Read Full Post »

More about SQL and Logical Files

This week’s tip: In your QAQQINI file, set IGNORE_DERIVED_INDEX to *YES.
So what does that mean? First, QAQQINI is a file that you can use to control query processing. If you’re not familiar with it, follow the links at the end of this article to learn about it.
At this point, I assume you know what QAQQINI [...]

Read Full Post »

Killing the Oracle DBMS_JOB

 
 while ago I published an article on Killing the Oracle DBMS_JOB. This was also a favorite of some of my readers and I still get questions on it today. So I thought I would post it here as it has surely been lost out in the web archives unless you search deep. Just remember the [...]

Read Full Post »

Using a Linked table

There are a couple of things you have to remember while using a linked table. The main one is how to reference the tables in the remote database. In the previous post, I mentioned that you have to assign a name to your linked table, and it didn’t have to be the actual name of [...]

Read Full Post »