0

I am newbie to DB2/AS400. working on an ETL project. basically, we need to "select" image files (*.bmp) stored on a AS400 server file system/share (not sure if this is the correct term but to differentiate it from a Database file/table).

I have other processes in a MS SSIS package already pulling data from this AS400 server database/tables (using MS DB2 Provider + SQL) successfully. But I do not know how to interact with AS400 file system from a Windows system. I can use the UI tool (iSerials Navigator i.e.) browse to those files.

I'd appreciate any pointer/help. Thanks.

Improve this question

2 Answers 2

Reset to default
3

I don't think this is related to DB2 at all. System i (formerly known as AS/400) supports NFS and so does Windows, so you should be able to define NFS shares on the server and mount them on Windows, giving you access to the files.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

IBM i also supports SMB (aka Windows) networking. The server side is "Netserver" www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/rzahl/… the client side is the /QNTC file system www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/ifs/…
@Charles - that's even better.
Note that SMB support in IBM i is somewhat outdated; namely no support of NTLMv2 authentication. Which can make using it with Windows 7/2008+ difficult. www-304.ibm.com/support/docview.wss?uid=nas8N1011371 and www-01.ibm.com/support/docview.wss?uid=nas8N1018525.
2

In IBM i terminology, we would probably say that files on a shared directory in the IFS [Integrated File System]. The software that delivers files over the network from the IFS is called NetServer. You should be able to read the files from a Windows application the same way you would read any other file over the network.

If you are seeking speed by delivering them from SQL Server, you would probably get faster delivery times by storing them in a BLOB column in a DB2 table, rather than SQL Server. DB2 is generally faster than SQL Server, and faster than the IFS.

Of course all this depends on what you are doing and trying to accomplish, among other factors.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.