cancel
Showing results for 
Search instead for 
Did you mean: 

AS400 Operating sytem

Former Member
0 Kudos

Hi All,

Can any body tell about AS400 operating system. Where does files(member files as well as ordinary files) get stored

in AS400 operating sytem and in what way they are stored. As per my knowledge AS400 comes with a inbuilt DB2 database.

In what ways I can connect to AS400 operating system from XI to get the data.

Thanks

Gujjeti

Accepted Solutions (1)

Accepted Solutions (1)

bhavesh_kantilal
Active Contributor
0 Kudos

Praveen,

Etiher use the file adapter to read the TXT files from the AS400 System ( if it provides files ) or use the JDBC adapter to connect to the DB2 Database and poll the data.

Regards

Bhavesh

former_member181985
Active Contributor
0 Kudos

Dear Bhavesh,

>>use the JDBC adapter to connect to the DB2 Database and poll the data.

Using JDBC adapter are we able to connect all files which reside in the directory or library (not in the database).

Thanks,

Gujjeti

bhavesh_kantilal
Active Contributor
0 Kudos

Praveen,

I have seen a use case when once the firewall has been opened we were able to poll directly to a DB3 database and take data from the AS400 mainframe system.

Make sure drivers are installed and the JDBC adapter has the connectivity and the authorizations to do this and you should be able to use the JDBC adapter.

Regards

Bhavesh

prateek
Active Contributor
0 Kudos

One more possibility:

If you can setup FTP server on As400, then you can use File/FTP adapter. This way handling file at directory level will be much more easier

Still if u want to continue with JDBC, have a look at Abhy's reply here

Regards,

Prateek

Former Member
0 Kudos

>>>Using JDBC adapter are we able to connect all files which reside in the directory or library (not in the database).

Praveen do you mean to ask if we can connect to a file in library? If so, the answer is <b>yes</b>.

We have done a integration in this approach. In the table name you need to specify the file name in this format

<Library name.tablename>

Regards,

Jai Shankar

ravi_raman2
Active Contributor
0 Kudos

Alright, Couple of tips here....DID you know you can map your windows system to the as400 system then use the file adaptor. That is a better way than directly using the file adaptor to get the files as there is an issue with ascii conversion.

As400 does come with inbuild db2, they used to be called as400..now terminology used is i5. This is just an internal name change with IBM as they changed the AIX servers to be called P Series, and other systems have been changed as well to be X Series and Z Series(Main Frames). i5 are also called midrange servers, their biggest advantage is scalability, multiple operating systems running simultaneously on different lpar`s, and an integrated centralized memory management system, This OS also has its own in build router that can be used to configure NAT etc. They dont need to be rebooted as often, i have only rebooted my as400 systems two times last year...:-).

Regards

Ravi

Answers (2)

Answers (2)

former_member181985
Active Contributor
0 Kudos

answered

prateek
Active Contributor
0 Kudos

<i>Can any body tell about AS400 operating system</i>

The System i (formerly known as iSeries, AS/400, and Application System/400) is a computer platform produced by IBM.

<i> Where does files(member files as well as ordinary files) get stored in AS400 operating sytem and in what way they are stored </i>

The AS/400 platform extended the System/38 architecture of an object-based system with an integrated DB2 database.

<i>As per my knowledge AS400 comes with a inbuilt DB2 database.</i>

Yes

<i>In what ways I can connect to AS400 operating system from XI to get the data.</i>

Database DB2 could be connected using JDBC adapter

<i>[Reward if helpful]</i>

Regards,

Prateek