How do I disable the query timeout property?

5 pts.
Tags:
AS/400 Client Access
AS/400 performance
AS/400 Query
I'm calling a stored procedure on the AS/400 from Visual Basic .Net. When the stored procedure executes, I get the SQL0666 message (query exceeds specified time limit or storage limit). The query timeout property on the box is set to *NOMAX and I've Reorg'd the files too. The message appears to be coming from the PC side and not the AS/400 side. I'm using the UDB DB2 data provider that comes with iSeries Access for Windows V5R3 and later. Does anyone know how to get around this? Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

I’d start by checking the system values on the AS/400 :-

DSPSYSVAL SYSVAL(QQRYTIMLMT)

Regards,

Martin Gilbert.

————————————————————
Did you check

http://www.itjungle.com/fhg/fhg071305-story03.html

Phil

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JasonWV
    [...] How do I disable the query timeout property? [...]
    0 pointsBadges:
    report
  • philpl1jb
    Here's a discussion on the query time out limits. http://www.itjungle.com/fhg/fhg071305-story03.html The other possibility is in the ODBC/JDBC driver settings. Phil
    49,600 pointsBadges:
    report
  • Abigail
    I am getting the same error. I'm on V5R4M0. System value (QQRYTIMLMT) set to *NOMAX.
    645 pointsBadges:
    report
  • BigKat
    If it appears to be on the PC side, you should add .NET tags to the question so the gurus over there can help you too.
    7,935 pointsBadges:
    report
  • Joelcochran
    When this happens, you need to set the iDB2Command CommandTimeout property to a specific value. I think the default is 30 seconds. Setting it to 0 is effectively *NOMAX. Here is a sample: iDB2Connection _conn = new iDB2Connection(ConnectionString, IpAddress, User, Password); iDB2Command = _conn.CreateCommand(); _cmd.CommandTimeout = 0; _cmd.CommandType = CommandType.StoredProcedure; // Add Parameters here _cmd.Parameters.Add(name, type, size.Value); _cmd.Parameters[name].Value = value; _cmd.Parameters[name].Direction = direction; _cmd.Prepare(); var q = _cmd.ExecuteNonQuery(); I would also recommend upgrading to the V5R4 .Net Provider SP1, it will stop that nagging ObjectDisposedException from being thrown at the end of the .Net program execution. -- Joel Cochran http://www.developingfor.net
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following