MVSFORUMS.com

Yes its been a while since the last post came in ..but only now I got some time to try things..

I have tried both the below with sample programs and the answer is YES to all
1) ENTRY DLITCBL is n ...

hi..any help appreciated..some code snippets wud help me build a new program using it and I will attempt as a case study..

Thanks Anuj..I have tried to look at those pages before posing the question...

I assume you agree that DLITCBL will not be required.
Unable to conclude on my query 2..I guess you are saying the ad ...

Hi..Need some advice on AIBTDLI calls..

As I understand by AIBTDLI usage we can refer PCBs by name rather than address (provided the name is coded in PSB).

Does this additionally mean
1) ENTRY ...

Sorry for the late reply..I found some buffer pools declared by default installation and managed to suggest a solution for this..

Sample DFSCTL card for OSAM Sequential buffer..

...

thank you ..it worked..

Hi

My online program(s) want to access a static table from IMS TM. The requirement to be able to design it in such a way that we do not read the same record from disk twice. Instead it needs to fir ...

To answer the other question..we are uploading a CSV file through front end ..this file can contain like 30K records..

SP is invoked by .NET front end..hence we are linking to CICS onlines via EXCI..

Dick..That kind of questions the basic requirement..

So you say even 1 or 2 EXCI calls could drain the CPU time ?

Many thanks for the inputs..

The only area which has never been explored is XML parse..and we are trying to see if it is a CPU drain

From the start we have been facing these issues..initially th ...

My primary suspects include

1) EXCI calls
2) XML PARSE of input done by SP
3) DB2 queries (note that there are no dynamic queries)
4) non-EXCI calls

One question..does this have to do with the complete SP execution ?
Or is it one single query that is causing this issue ?

Failed to upload file. Cause: ERROR [57014] [IBM][DB2] SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "DBTPIAC.IACS315A", limit = "0000000021" ...

Hi

I am trying to run a Stored Procedure and it results in SQL0905..I tried to google and arrived at issue with ASUTIME. The ASUTIME defined for the SP is huge..but somehow it does not complete wi ...