1 hour ago by Sheeri Cabral

I confess — I have not always been an exclusive MySQL user. I have fooled around with other DBMSs. I was young, inexperienced, and I needed the money, I swear! This comes about because I was doing some electronic de-crufting….From a file last modified on 10:50 am on 2005-06-30: > more addcatalog.sh ...

Pythian Group Blog - pythian.com/blogs · Rank: 5,163 · 106 references

14 hours ago

Hi VK, you can use db2move to copy a tables from one schema to another even with in the same database. !***! Entry Link: Redirected Restore Script Builder!***!

Comments on All ITtoolbox ... - it.toolbox.com/blogs · Rank: 9,707 · 63 references

14 hours ago

Check to see if the port number is being used by some other service (i.e. they can't be the same for local and remote because they are both on the same machine) and make sure they are not ports also being used by DB2 (either for the client communication to the server..svcename, or 1 greater than tha ...

Comments on All ITtoolbox ... - it.toolbox.com/blogs · Rank: 9,707 · 63 references

19 hours ago

This sample was just what I was looking for. Thanks for posting this! CURRENT DATE - ((18 * 365) + RAND()*(47*365)) DAYS, I remorked this into a TIMESTAMP I needed: CURRENT TIMESTAMP - ((18 * 365) + RAND()*(47*365)) DAYS !***! Entry Link:http://it.toolbox.com/blogs/db2luw/how-to-easily-populate-a-ta ...

Comments on All ITtoolbox ... - it.toolbox.com/blogs · Rank: 9,707 · 63 references

1 day ago

Hi Chris, Need your advice regarding HADR. I'm trying to do a demo session here with client to show HADR functionality in DB2 UDB V8.2 on Windows platform. I'm trying to do HADR for database across two different instances in one single machine (this is just for demo - so using one single host). Crea ...

Comments on All ITtoolbox ... - it.toolbox.com/blogs · Rank: 9,707 · 63 references

1 day ago

Hello Chris , Thanks for your message. I copied a production database db2 version 8.1 to Quality (R3P to R3Q). The restore redirect completed successfully. I am able to connect to the restored database. The schema on R3P was sapr3p. The schema on the restore database is now sapr3p. But the applicati ...

Comments on All ITtoolbox ... - it.toolbox.com/blogs · Rank: 9,707 · 63 references

1 day ago

Willie, It always been conducive for the professional advancement to learn few tricks from the history and remind him or herself the importance of basics.Right now what is happening, the product getting more and more complex and the documents trying to cover that with less and less detailed informat ...

Comments on All ITtoolbox ... - it.toolbox.com/blogs · Rank: 9,707 · 63 references

1 day ago by ibrahim

We are pleased to announce the release of release Centerprise Data Integrator 3.0. This release represents a major upgrade with a completely redesigned user interface and hundreds of additional features. APIs have been refined and extended. Server received major functionality, security, and performa ...

Astera Company Blog - community.astera.com/blogs/asterablog

1 day ago by Iqbal

For those of you using Linux on the Itanium-64 bit (IA64) platform, note that DB2 9.5 is not available for Linux on IA64. The last supported DB2 version for Linux on IA64 is DB2 9. This is because Linux on IA64 is not a high growth platform for IBM and in fact quite the opposite. [...]

Planet DB2 - planetdb2.com · 4 references

1 day ago

Hi JJ, CLOBS are not put into the DB2 bufferpool (as they could quickly flood the bufferpool and leave little room for row data that may be frequently accessed). However if you want to access LOBs frequently then you can put them in a tablespace and let the file system cache them. Most filesystems w ...

Comments on All ITtoolbox ... - it.toolbox.com/blogs · Rank: 9,707 · 63 references