Re: V5R2 Access ODBC Allow Query Timeout -- MIDRANGE-L

Found the following at the Improved Search site (www.iseris.ibm.com/support and click on search, upper right corner). R520 refers to the ODBC release, not OS/400.

In R520 and later the QueryTimeout property can be accessed using the ODBC Data Source Administrator utility. In the iSeries Access for Windows ODBC Setup Dialog, select the Performance tab and click the "Advanced" button. On the Advanced Performance Options dialog uncheck "Allow query timeout".

R510 and earlier also support this setting but the option is not available in the datasource setup. To disable query timeout the string value QueryTimeout must be added to the data source registry key and set to 0 . The cwbODBCreg tool can be used to set this option. The syntax is: cwbODBCreg myDSN QueryTimeout 0 where myDSN is the ODBC datasource name. The cwbODBCreg tool is available at

<ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/files/odbc_tool/cwbODBCreg.zip>ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/files/odbc_tool/cwbODBCreg.zip<ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/files/odbc_tool/cwbODBCreg.zip> .

I didn't know about the tool before - cool!

HTH
Vern

At 11:45 AM 3/16/2004 +0100, you wrote:

Folks, we just upgraded to V5R2 last weekend and things work fine except
for ODBC queries.

We make extensive use of COGNOS, which up to now (OS7400 V4R5...) gave us
no problems.

Since the update to V5R2, reports extracted from AS/400 database via Cognos
just show "part of the lines" we should get but NOT ALL !
So we just get "part of the rows" for the report but not all of them...

This happens bot with PC's running old Access Express 4.5 ( + SF64217) and
with PC's running the new Access for Windows 5.2 ( + SI10914).

Since we are BPCS users, during the upgrade to V5R2 we had to create a
QAQQINI file in QUSRSYS with the SUPPRESS_SQL_WARNINGS line in it.
We have tested with just this line only, and also after adding a line
QUERY_TIME_LIMIT  present in QSYS/QAQQINI  with a value of *NOMAX.

System value QQRYTIMLMT = *NOMAX

Searching thru different forums (Midrange included, of course...) we've
found some entries dealing with this problem, with COGNOS and/or Windows
ACCESS. Someone mentioned an attribute called "Allow Query Timeout" in the
Advanced_Performance_options panel (Performance sheet in ODBC definition),
but as he himself mentioned, this did not fix it either... We tried it and
did not get any better.

Someone also pointed to some Windows Registry value he could not
remember...

Anyone has got a solution for this?
TIA

Juan Carlos

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.