IBM Guardium

IBM Guardium

Join this online user group to communicate across Security product users and IBM experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  RestAPI Client and IBM Guardium

    Posted 13 days ago

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


  • 2.  RE: RestAPI Client and IBM Guardium

    Posted 19 hours ago

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

    Original Message


Related Content