Recent content by SnowCrash7

Running DB2 9.7 LUW on AIX and Red Hat Linux. I am asking for thoughts on architecting this environment going forward. Most of my background has been with huge OLTP and EDW databases with mostly a 1 or 2 databases to one instance configuration. So this is very different for me. Taking a new...

Thanks for the reply. The sql I was provided by the app team is not correct. If I can get them to provide me with the right sql I will post. Thanks

Running DB2 101 fp2 on Red Hat Linux. We have a query that repeats several times consecutively. The issue is that the subsequent execution times are not running faster than the first execution. I would think that the explain plan, once in the sql cache, would enable quicker times on subsequent...

DB2 LUW version 9.7 running on Red Hat Linux. I want to activate the Storage Optimization feature via the db2so.lic license. I apply the license via db2licm. Is it mandatory that I bounce the instance to activate that feature? Thanks

I'm relatively new to DB2 on AIX. Is there a best practice suggestion for locating the db2 dbtools db in the UDB on AIX file structure? I understand that it normally should go under the Instance directory. Thanks in advance.

I am running Win 2K Pro on a Compaq Presario. When I go into the Control I'm a programmer and have run into a problem beyond my purview. I am running Win2K Pro on a Compaq Presario. When l try to open the Add/Remove Programs window, I get this error message: An unexpected error occurred...