SPUPad

You can use the SPUPad feature to reserve temporary areas of memory on the SPUs (also known as S-Blades). The SPUPads are typically used to hold data for use with user-defined functions.

When the query or transaction block that created the SPUPad finishes, the Netezza Performance Server system releases the memory that is allocated for each SPUPad. SPUPads usually reside in memory on the Netezza Performance Server SPUs where the user data tables are, but they can also reside on the host if the UDX is operating on external tables or host-based system views.