on 06-05-2007 10:36 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
>>>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
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
answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.