12.22.4 Processing when there are no available temporary table RDAREAs

If no temporary table RDAREAs exist when HiRDB attempts to store data in a temporary table, HiRDB issues the KFPA19704-E message and ignores the transaction. In such a case, the cause of the error indicated in the KFPA19704-E message applies only to the first storage candidate RDAREA. If you have taken appropriate action for the RDAREA displayed in the message but the same message is issued again, check the status of other temporary table RDAREAs and take appropriate action for them also.

Action to be taken:
Execute the pddbls -T command.
Check the execution results to see if there is an RDAREA for which OCCUPIED or SHARED is displayed for RDAREA_FOR_TEMPORARY_TABLE.
  • There is no RDAREA for which OCCUPIED or SHARED is displayed
    If there are no available temporary table RDAREAs, you must add a temporary table RDAREA with the SQL session-specific attribute. If necessary, specify that RDAREA in PDTMPTBLRDAREA in the client environment definition.
  • There are RDAREAs for which OCCUPIED or SHARED is displayed
    If there are temporary table RDAREAs, then none of them satisfies the storage conditions (for details about the storage conditions, see 12.22.3(3) Choosing the RDAREAs that satisfy the conditions). In order to determine which conditions are not satisfied, execute pddbls -a -T and pddbst -k -phys on the temporary table RDAREAs. Check the execution results for the items described in the table below and take appropriate action for the conditions that are not satisfied.

    Table 12-29 Check items and actions

    No.CommandCheck itemDescriptionAction
    1pddbls -a -TSTATUSRDAREA's statusIf the RDAREA is in any of the following statuses, you must take the appropriate action explained below:
    • Closed
    • Shut down
    • Status in which the pdhold command has been accepted
    Change the RDAREA status by opening it or releasing its shutdown status so that the UAP can access the RDAREA. If the RDAREA is in error shutdown status, use the pdmod command to re-initialize the temporary table RDAREA (initialize rdarea statement).
    2SEGMENTNumber of unused segments in the RDAREAIf there are no unused segments, use the pdmod command to take one of the following actions:
    • Add a temporary table RDAREA (create rdarea statement)
    • Re-initialize the existing temporary table RDAREA (initialize rdarea statement)
    • Expand the existing temporary table RDAREA (expand rdarea statement)
    • Change the attribute of the existing temporary table RDAREA (alter rdarea) to apply automatic extension.
    3pddbst -k -physPage SizeRDAREA's page lengthIf the condition for page length is not satisfied, take one of the following actions:
    • Add a temporary table RDAREA that satisfies the condition for page length.
    • Change the page length of the existing temporary table RDAREA so that it satisfies the condition.
    4Unused SegmentNumber of unused segments in the RDAREASame as 2 above