Fetching Page Size from Teradata tables

Database

Fetching Page Size from Teradata tables

Can we extract the Page Size from any of the logging tables? We want to pull out page size for each node.

FYI: Temporary Storage Page Size is available through the utility 'dbscontrol'.
2 REPLIES

Re: Fetching Page Size from Teradata tables

"Tempory Storage Page Size" controls only the management of scratch memory within the RSG with the replication feature. If you are not using replication, it is immaterial.

By "page size", if are thinking of the host operating system's virtual memory page size, that is managed by the OS, not Terdata. On the other hand, if you mean disk pages in the Oracle or DB2 sense, Teradata does not use that concept.

Re: Fetching Page Size from Teradata tables

Thanks for the explanation Jim. I was referring to system's virtual memory page size (managed by the OS), Can we find that through any of the logging tables?