Posts

Showing posts from February, 2018

How to search using particular keyword in all files in a directory (UNIX)?...

How to search using particular keyword in all files in a directory (UNIX)?...   find . -iname "*.sql" | xargs grep -i "REG_NUMBER"
How to get file count in sftp server (Unix)?...   find . -type f -name "*.txt" | wc -l
How to get the table name list using particular database name. select * from _V_Table where database like '%DB_NAME%' order by tablename;

How to get column name wise table name list in particular database (Netezza).

How to get column name wise table name list in particular database (Netezza).     select distinct table_name from DB_NAME.._v_sys_columns where column_name in ('Reg_Number') order by 1;  
How to get user level database access details in netezza server:   select * from _v_sys_priv where username= ‘Username’ and objecttype='DATABASE';
How to get the database size in netezza server:   SELECT o.dbname DatabaseName,((SUM(z.ALLOCATED_BYTES)/1024)/1024)/1024 AllocateSpaceGB,   ((SUM(z.Used_BYTES)/1024)/1024)/1024 UsedSpaceGB, (AllocateSpaceGB-UsedSpaceGB) FreeSpaceGB   FROM _V_SYS_OBJECT_DSLICE_INFO z   JOIN _v_object_data o ON o.objid = z.tblid where DBNAME = 'DB_NAME' GROUP BY o.dbname order by o.dbname;