Friday, September 29, 2006

Cross Platform Issues

Here are some thoughts I had regarding cross platform issues on iSeries:


  • Big plus: Virtually unlimited scalability through network server storage spaces. Running tight on disk ? Just create more and attach it to the network server description with simple commands.
  • Big minus: Nightly saves of those storage spaces using native i5/OS commands are best at the disk image level. Effective saves at the object level require Tivoli or BRMS.

  • Big plus: IBM freely distributes its ODBC driver with iSeries Access for both Windows and Linux, allowing applications on those platforms to tap your DB2 data
  • Big minus: Nobody else freely distributes their database drivers (for MS-SQL, Oracle, etc.) for iSeries based applications to draw from them. Thanks for nothing.

  • Big plus: Several POWER compatible Linux distributions are available for download over the Internet.
  • Big minus: The documentation for iSeries deployment of these distributions is a little too cryptic to be useful to most midrange professionals.

  • Big plus (so they say): AIX can now be run in a logical partition on iSeries.
  • Big minus: Has anyone besides IBM actually done this ?

  • Big plus: Integrated xSeries servers allow a hot spare to replace a failed IXS with a few simple commands.
  • Big minus: Adding IXS cards can push you into costly, underutilized expansion towers.

  • Big plus: IXS cards tend to be very stable because their product development cycle lags behind those of other Intel products.
  • Big minus: IXS cards tend to be frowned upon by Windows based software vendors, because their product development cycle lags behind those of other Intel products.

Please feel free to share your thought's.

Thanks, Chris

4 Comments:

At 7:55 AM, Anonymous Anonymous said...

I'm not happy with the direction the iSeries is going. Building a Swiss Army Knife (do everything) system is wrong. A Swiss Army knife is NOT and good knife. I have carried a single blade pocket knife for years. IBM makes great Linux and AIX systems why merge them into the iSeries box. Just because you can doesn't mean you should.
The focus should be on building a better iSeries (OS/i5) box. We have such a great foundation to work from.

 
At 8:01 AM, Anonymous Anonymous said...

Now that we are running Linux and AIX on the i5 are there any good tools for porting a UNIX SQL DB to DB2/400? FTP would convert the ASCII to EBCDIC. I'm assuming the SQL scripts would just need to be reviewed for syntax. The bigger issue is getting field level detail.

 
At 9:05 AM, Blogger Christopher F. Burns, Sr. said...

I can see value in Linux, but not AIX (at least in our market space). If I had a Unix application, I would be looking toward porting it to Linux before porting it to AIX or i5/OS. The skill sets are comparable.

I do agree that there are some fundamental things on i5/OS that would be more useful than any Swiss Army knife initiatives.

As far as porting data, the only real technique I have used has been to use whatever "Generate SQL" tool was available on the platform and run that script in Ops Navigator's database wizard. I would also check AlphaWorks (http://www.ibm.com/alphaworks) because they have a slew of gorpy tools like that.

I've done this with MySQL databases on Linux and all I had to ensure was that the naming convention on JDBC setup (format tab) was "SQL Naming".

 
At 1:49 PM, Anonymous Anonymous said...

Thanks, I had forgotten about alphaworks for tools.

 

Post a Comment

<< Home