Profile

Cover photo
Girish Srivastava
Lives in Bangalore
96 followers|45,691 views
AboutPostsPhotosYouTube

Stream

Girish Srivastava

Shared publicly  - 
 
Netezza Important commands...
To find database 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 ...
1
Add a comment...

Girish Srivastava

Shared publicly  - 
 
My First Published Book as a Reviewer... (Mastering EXT JS)
I would like to thank the Almighty, my parents, B.M.P. Kiran and Mina Devi, my family, and my loveable friends, who have supported and backed me throughout my life. I would also like to thank Rawal Thakur, the managing director of my company, who gave me br...
1
Add a comment...

Girish Srivastava

Shared publicly  - 
 
NZ_MIGRATE utility
NZ_MIGRATE  utility is used to migrate data from source database to the target
database. All the tables mentioned in the tablelist parameter are
migrated to the target database. There are options to create target
tables or truncate target tables before m...
1
Add a comment...

Girish Srivastava

Shared publicly  - 
 
The nzreclaim command
Use the nzreclaim command to recover
disk space that is used by updated or deleted data by using the GROOM
TABLE command. Note: Starting in release 6.0, the SQL GROOM
TABLE command replaces the nzreclaim command. The nzreclaim command
is now a “wrapper” tha...
1
Add a comment...

Girish Srivastava

Shared publicly  - 
 
Sakila DB Installation in MySql
The Sakila sample database is available from http://dev.mysql.com/doc/index-other.html .
A downloadable archive is available in compressed tar file or Zip
format. The archive contains three files: sakila-schema.sql , sakila-data.sql , and sakila.mwb . The s...
1
Add a comment...
Have him in circles
96 people
Chandan Kumar Mohanty's profile photo
Yuvi Vs's profile photo
Mahendran Natarajan's profile photo
Dipak Singh's profile photo
m.s.sravan Mothukuri's profile photo
Shilpa Bhat's profile photo
yogendra singh's profile photo
Satya brata Nayak's profile photo
rohan gupta's profile photo

Girish Srivastava

Shared publicly  - 
 
SQL query to find Distribution key of all tables in a Netezza Database
Run the following command in your connected database. SELECT tab.tablename ,COALESCE(map.attname,'RANDOM') AS distribution_key
      ,map.distseqno AS dist_seq_no FROM _v_table tab 
LEFT OUTER JOIN _v_table_dist_map map 
ON map.objid = ...
1
Add a comment...

Girish Srivastava

Shared publicly  - 
 
Netezza Metadata Queries
1. Query to get a list of views and thier definitions in a database: SELECT VIEWNAME,OWNER,CREATEDATE,DEFINITION FROM _V_VIEW WHERE OBJTYPE='VIEW'; 2. Query to get a list of tables in a database: SELECT TABLENAME,OWNER,CREATEDATE FROM _V_TABLE WHERE OBJTYPE...
1
Add a comment...

Girish Srivastava

Shared publicly  - 
 
nzbackup vs nz_backup
There are 2 commands to perform backup of Netezza.  One is nzbackup.
 The other one is nz_backup.  For nzbackup, not much you can play with
it except you need to specify the database to backup.  However,
nz_backup provides more command options eg, specif...
1
Add a comment...

Girish Srivastava

Shared publicly  - 
 
The relationship between groom and nzbackup
There are three basic functions that every Netezza DBA must perform regularly: Ensure statistics are up to date Groom your tables Backup your production databases Let’s focus on groom and its dependency on nzbackup.  I recently ran
into an issue where groo...
1
Add a comment...

Girish Srivastava

Shared publicly  - 
 
IBM PureDataSystem for Analytics
                          IBM® PureData™ for Analytics, powered by Netezza technology, is changing the game for data warehouse appliances (again). Designed to help you unlock data’s true potential, the new IBM PureData System for Analytics is: Big Data and ...
                          IBM® PureData™ for Analytics, powered by Netezza technology, is changing the game for data warehouse appliances (again). Designed to help you unlock data’s true potential, the new IBM PureData System...
1
Add a comment...
People
Have him in circles
96 people
Chandan Kumar Mohanty's profile photo
Yuvi Vs's profile photo
Mahendran Natarajan's profile photo
Dipak Singh's profile photo
m.s.sravan Mothukuri's profile photo
Shilpa Bhat's profile photo
yogendra singh's profile photo
Satya brata Nayak's profile photo
rohan gupta's profile photo
Basic Information
Gender
Male
Birthday
September 11
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Bangalore
Links