DB2 parallel edition on AIX

[PSD]

Hi,

I am an AIX system administrator and as such my knowledge of DB2 is not great. My company is looking into DB2 parallel edition for our SP nodes, does anyway have any experiences of this? good or bad would be helpful.

I suspect that I will use GPFS for data sharing.

Thanks PSD
IBM Certified Specialist - AIX V4.3 Systems Support
IBM Certified Specialist - AIX V4 HACMP

 

[EdVassie]

DB2 PE has been obsolete for many years (It relates to DB2 V2.1.2 I think).

The current DB2 release is DB2 7.2

You should look at DB2 Enterprise Edition if you can grt your application to fit into a single box. DB2 EE can support many CPUs on the box, and can support clustering for fail-over. Parallelism within a query is well supported. Most vendors that supply tools for DB2 on AIX have a DB2 EE version before they tackle DB2 EEE.

If you need more than one box for your application, look at DB2 Enterprise Extended Edition (DB2 EEE). This uses a shared-nothing architecture over several nodes. Each box/node contains a portion of your data. Each node can have multiple CPUs. DB2 EEE can give you more horse-power to run your queries than is possible on a single box, but is also more complex to administer. Many vendors do not have DB2 EEE versions of their tools, which does not help. This posting is a personal opinion only, and may not reflect reality.