15.10 - Parcel Ordering - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

The response returned from a MONITOR request is a series of parcels constructed by Teradata Database and sent to the client.

The basic parcel layout for a successful response is the same for most MONITOR requests, except the following:

  • MONITOR SQL
  • MONITOR VERSION
  • Some MONITOR requests such as:

  • MONITOR SESSION
  • MONITOR VIRTUAL CONFIG
  • MONITOR PHYSICAL CONFIG
  • MONITOR VIRTUAL RESOURCE
  • MONITOR PHYSICAL RESOURCE
  • behave like multi-statement requests, for which multiple record parcels are returned. For request-specific parcel layout, see Chapter 4: “System PMPC APIs.”

    The following table shows the parcel layout for an unsuccessful response is the same for all MONITOR requests -- either a Failure or an Error parcel is returned.

     

    Parcel Name

    Parcel Flavor

    Field Length

    Comments/Key Parcel Body Fields

    Failure

    9

    15 to 267

    Message code and message text: description of cause of failure; request could not be processed. For example, the request is aborted.

    Error

    49

    15 to 267

    Message code and message text: description of cause of error. Application can fix the problem and resubmit the request. For example, response buffer is too small to hold entire response row.