StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Have you tried setting the <code>HS_FDS_CONNECT_PROPERTIES</code> parameter in the AS400 Transparent Gateway initialisation file?</p> <p>For a timeout of 2 minutes:</p> <pre><code>HS_FDS_CONNECT_PROPERTIES="timeout='120'" </code></pre> <p>Another more general option for setting a query timeout is to create a <strong>profile</strong> and assign it to the user running your query.</p> <p>A resource profile can be used to set limits on all sorts of usage in any particular session - one resource limit available is connection time.</p> <p>For example, you could create a profile <code>as400_tg_profile</code> and assign it a maximum connection time of 2 minutes:</p> <pre><code>create profile as400_tg_profile limit connect_time 2; </code></pre> <p>... then you could assign this profile to the user running the query:</p> <pre><code>alter user as400_tg_user profile as400_tg_profile; </code></pre> <p>There are lots of options on creating a profile and there are many ways to assign a profile to a particular user so you should read through the documentation.</p> <p>You could also look into using Oracle Resource Manager creating resource groups and resource profiles if you need to dynamically assign particular resource limits - this gives you fine-grained control of resources for individual sessions.</p> <p>The <a href="http://www.oracle.com/pls/db102/homepage" rel="nofollow noreferrer">Oracle documentation</a> is really good on this - for starters, give this a read:</p> <p><a href="http://www.oracle.com/technology/products/manageability/database/pdf/twp03/twp_oracle%20database%2010g%20resource%20manager.pdf" rel="nofollow noreferrer">http://www.oracle.com/technology/products/manageability/database/pdf/twp03/twp_oracle%20database%2010g%20resource%20manager.pdf</a></p> <p>For more detail:</p> <p><a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dbrm.htm#ADMIN027" rel="nofollow noreferrer">http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dbrm.htm#ADMIN027</a></p> <p>This is one of those bits of functionality that's easier to use in Enterprise Manager, but a quick PL/SQL example is given in:</p> <p><a href="http://www.dba-oracle.com/job_scheduling/resource_manager.htm" rel="nofollow noreferrer">http://www.dba-oracle.com/job_scheduling/resource_manager.htm</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload