Re: Help with DB2 and DOT.Net performance

Gio,

Have you checked the block size? (you need to enable Extended Dynamic and the Package Name) . If slowness comes from fetching sometimes you can improve performance by growing your block size to something like 256K ~ 1024K.


El 03/07/17 a las 20:15, Matt Olson escribió:

Why are you using the ODBC driver in .NET? You should use the IBM i .NET Driver for best performance.

ODBC has a lot of overhead (aka, its SLOW).

________________________________________
From: gio.cot <gio.cot@xxxxxxxxxxx>
Sent: Monday, July 3, 2017 5:11 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Help with DB2 and DOT.Net performance

Hi all we have performance problem with Dot.Net Sql reads on IBM I ; this is
the scenario



1. Our Windows software POS, in some procedures, reads IBM I DB2 for
retrieve inventory quantity or other information ; this reads are done with
Sql statement , via Client Access ODBC driver .
2. From about two weeks , only in some days (Friday and Saturday) we
have big trouble with performance , as the Sql reads consume in some moment
(QZDASOINIT Jobs) higth CPU percentage and IBM I is very slowwwww !!
3. Keep in mind that :
a. the IBM I run IPL only Sunday morning
b. that Friday and Saturday , the logistic and accounting offices
don't use IBM I , so the performance should be better, also if probably,
the shops have more transaction and so more reads SQL at IBM I
4. The only thing that was changed from two week to today, is that was
installed a new version of Windows software POS ; the new version respect
to the previous , is that was used the new Framework of dot.net (I think the
4.5 or 5 .. sorry but I don't know the windows/dot.net world.. I can ask to
my colleagues) but the SQL statement are not changed (this SQL statement
are many year the work with out performance any problem )
5. We found and followed the instruction at this link
http://www-01.ibm.com/support/docview.wss?uid=swg21572206 (CHGPJE
SBSD(QUSRWRK) PGM(QSYS/QZDASOINIT) MAXUSE(1)) but nothing changed, the
problem remains ..

Can some one help/suggest some link for find the problem
Thanks in advance

Gio


Notes :
IBM I run V7R2

PTF Status :
ID TITLE INSTALLED
SF99776 HIGH AVAILABILITY FOR IBM I 6
SF99775 HARDWARE AND RELATED PTFS 19
SF99767 720 TCP/IP PTF 3
SF99766 PRINT PTFS 3
SF99720 CUMULATIVE PTF PACKAGE C6306720 16306
SF99719 GROUP HIPER 77
SF99718 GROUP SECURITY 39
SF99717 TECHNOLOGY REFRESH 5
SF99716 JAVA 11
SF99715 BACKUP RECOVERY SOLUTIONS 27
SF99714 PERFORMANCE TOOLS 4
SF99713 IBM HTTP SERVER FOR I 19
SF99702 DB2 FOR IBM I 14








--
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.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD