Hi, 

We tried to connect and fetch data from IBM Guardium to one of Client using RestAPI.

It was working fine, finally we increased fetched size to 60000 records, and it prompted and error.

"ErrorCode":"1002"

"ErrorMessage":"Create_online_report:30000 is the maximum fetch size"

Q 1 :: Can we increase this fetch size?

Q 2 :: What is impact on IBM Guardium regarding load processor, memory and any impact on sniffer working?

------------------------------
Asad Ullah
------------------------------

You must handle this programmatically.

To prevent returning excessively large result sets from a single API call, a hard limit is enforced.

When building automation, you should split large result sets into smaller chunks and retrieve them using multiple sub-requests. This is done by using the indexFrom parameter together with fetchSize.

How indexFrom works

• indexFrom specifies the starting index of the first record returned in a given request.

• fetchSize defines how many records are returned in that request.

To retrieve the next portion of data, increment indexFrom by the previous fetchSize.

Example

• First request:

  • indexFrom = 1

  • fetchSize = N

• Second request:

  • indexFrom = N + 1

  • fetchSize = N

• Continue increasing indexFrom until the API returns no records.

Recommended approach

Replace a single API call with a loop that:

1. Executes the request with the current indexFrom

2. Processes the returned data

3. Increments indexFrom

4. Stops when the response is empty

This approach ensures reliable automation while staying within API limits.

------------------------------
Zbigniew (Zibi) Szmigiero
IBM
Międzyrzecz
------------------------------