DB2

Replication Cold Start
I have 2 databases in two different instances that I am doing one-way replication to. I will be cold starting the replication when I first initialize it. But I do not want the target table to be refreshed. I have sychronized the capture side and apply side tables using export- import and then changed some column va... 12 Mar 2010 08:17

Doing a join on a non-numeric column?
Greetings. I'm trying to execute a DB2 command such as: SELECT P.ITEM_NO, D.FILE_NAME FROM PRODDB2.PART P LEFT JOIN PRODDB2.DATA D ON P.OBJ_ID = D.OJB_ID but I get: "D.OJB_ID" is not valid in the context where it is used. SQLSTA... 11 Mar 2010 08:53

confirm trusted context from remote reporting server
Is there a query from a snapshot table, or some other method, to monitor that a database is using trusted context connections? My company is requesting that I run a report from our monitoring server and report any non-compliant databases. Any assistance would be greatly appreciated. We are running DB2 V9.5.0.4 o... 10 Mar 2010 18:40

Discover Location Intelligence
For traditional reporting, the dimensions of who, what, and when (customer, product, time), are well covered, however, the "Where" gets little attention. Location Intelligence, the mashup of Business Intelligence with GIS, brings visibility to the "where". Yellowfin's tech team have produced the following whitep... 10 Mar 2010 06:22

Nlevels and optimizer
I have a Primary Key Index that has 11 columns in it. 80 million row table. The index is 100% clustered and has nlevels = 4. We have an Update statement that should use this index but chooses not to. Which causes the update to scan about 10000 rows before the row to be updated is found. If I lie about the s... 8 Mar 2010 16:23

Install question
I installed DB2 9.5.1 a while back on Windows XP. After completing that installation, whenever I open Firefox, I get asked which profile I want to use for Firefox, my default one or DB2_LP. Why did the DB2 installation create this DB2_LP profile and what is the benefit? Should I be opening Firefox with the DB2... 9 Mar 2010 11:09

Error migrating DB2 Express C from 9.5 to 9.71
On my XP sp3 box, I tred to upgrade my DB2 Express C 9.5 to 9.71, but I received the error SQL5055C during the DB2EXTSEC phase. Now I can't open neither the command center, nor the CLP, receiving the same SQL error. Notice that, before upgrading, I run db2ckupgrade.exe which told me that I can upgrade my DBs... 9 Mar 2010 12:18

Working with Ruby on DB2 ESE
Anybody has a write-up on installation and usage of Ruby with DB2 9.5 ESE on AIX 5.3/6.1? TIA ... 5 Mar 2010 15:03

Nested MQT's(Materialized view in DB2)
Hi, here i have given my requirement details please give me some idea.......... i have created a new user(user2) in db2 database.now In that database i have 2 users(user1,user2). in user1 we have more than 700 tables. i want to move data with structure from user1 to user2. how to move data with sructure fr... 5 Mar 2010 12:46

What's throttling?
Hello, DB2 v. 9.7.1. During certain special workloads (e.g. parallel REORGs/RUNSTATs), I've seen the server consuming 450MB/s with 25000IO/s (yes, there is probably some storage system caching happening here) while all CPU cores were happily working in an even mix of usermode/wait. And disk benchmark tools ... 5 Mar 2010 02:52