Netezza cheat sheets

If you want to databases size in Netezza SELECT ORX.database::nvarchar(64) AS"DatabaseName", case when sum(SOD.allocated_bytes)is null then 0 elseSUM(SOD.allocated_bytes)/1073741824end AS "AllocatedSpace_GB" FROM _V_SYS_OBJECT_DSLICE_INFO SODINNER JOIN _V_OBJ_RELATION_XDB ORXON ORX.objid = SOD.tblid GROUP BY "DatabaseName" ORDER BY "DatabaseName" -- how-to create a database CREATE DATABASE DatabaseName; -- how-to rename a database…

Continue Reading
Close Menu