Errors :(

I got a error: "SQL0668N Operation not allowed for reason code 5".

The web and DB2 help gave me the description that a load was busy hapening which in this case was not True.
In the end the real error was because I had was doing a load as below:

DECLARE CURSOR1 CURSOR FOR
SELECT column1,column2
from table1 where ID not in (select ID from TABLE2);



LOAD FROM CURSOR1OF CURSOR
    INSERT INTO table2 (col1,col2);

Because the Cursor contains the table in which the load is being done it gives the reason code 5.

IBM Data studio

A quick update on my experience.  The selects is working great, the only thing I am missing currently from my winsql is that I can click on a foreign key and it retrieves the row for me.

Optimization

Next week I am planning a in-depth analysis on my experience in optimization a data take on script. The scripts writes 20 million to a staging file then do data manipulation and writes to several different tables.

Then there is about 1 million records to be compared with the 20 million records and then written to a staging area and then manipulated before written to multiple tables.

IBM Data Studio

Because of the JAVA it takes a bit of resources and is a bit slow. Otherwise I have no complaints. All the database and sql management operations can be done on this tool.

Some searching may be required to do some advanced operations.

IBM Data studio

Update:

First impressions is not bad, the only current issue I have is the amount of data that has to be downloaded. The initial download is to installation package about 160mb then a further 800mb for the rest of the packages. 

New Development Tool

Downloading the IBM Data studio and will give feedback if it actually helps in a business environment. The reason for downloading is that I have a couple of functions and scripts that needs some debuging and statistical information. So hopes this helps.

Current development software is WINSQL...

http://www.ibm.com/developerworks/downloads/im/data/