If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 on AS/400

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-15-10, 03:49
db2cap db2cap is offline
Registered User
 
Join Date: May 2010
Posts: 87
DB2 on AS/400

Hi friends,
Its almost been three years I have been working on db2 LUW. Now I have an opportuninty to work on AS/400.

1. Is the administration of db2 on LUW and AS/400 same or is completely different?
2. Only OS level commands will defer or db2's behaviour(syntax-wise or execution-wise) will also be changed?

How do i start, i am given only a weeks time to explore the differences; will it be possible for me to understand and take the responsibilities given a weeks time?
Reply With Quote
  #2 (permalink)  
Old 09-16-10, 03:08
iksior iksior is offline
Registered User
 
Join Date: Sep 2010
Location: poland
Posts: 7
DB2 on AS/400

Administration of db2 on iSeries is completely different, it's easier to say about differences than similarities. Db2 on iSeires is integrated with operating system i mean if you install os you have db2. so, no tablespaces, containers, bufferpools etc. Engine i think is almost the same(sql, optimizer, governon, access plans).
But again even in SQL there is some differences.
From administrator point of view it's more simple to administer db2 on iseries. There are only operating system command and tools to do it. If you want same more information let me know i will send you some links...
Reply With Quote
  #3 (permalink)  
Old 09-16-10, 03:14
db2cap db2cap is offline
Registered User
 
Join Date: May 2010
Posts: 87
Thanks iksior...Please also send me the links.
Reply With Quote
  #4 (permalink)  
Old 09-16-10, 03:45
iksior iksior is offline
Registered User
 
Join Date: Sep 2010
Location: poland
Posts: 7
you should find everything here:
IBM DB2 for i
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On