On Tuesday, 08/19/2008 at 10:41 EDT, "Martin, Terry R. (CMS/CTR) (CTR)" <[EMAIL PROTECTED]> wrote:
> We have two environments that we are building as part of our POC. We > ship data via DB2 Connect from the mainframe DB2 to a Linux guest via a > HiperSockets Network. In our DEV environment all of our tables process > without issue. In our VAL environment there are six tables that the SQL > fails for. We have been engaged with IBM via a PMR on this and have been > going back and forth. At this point it appears that the issue is with > the number of rows. In the SQL when they do an SELECT * and do not > specify the rows it works. When they specify the tables in the Select it > apparently increases the size of the SQL and it never gets to the > mainframe. It looks like it is a 2k buffer limitation somewhere. Is > there anything in the TCP/IP stack in z/Linux or any network setting in > z/Linux that would enforce this limitation? Verify that the MFS (CHPARM= or OS= in IOCP) and MTU for the HiperSockets connection are the same for your DEV and VAL environments. Alan Altmark z/VM Development IBM Endicott ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
