Profile

Cover photo
Girish Srivastava
Lives in Bangalore
88 followers|42,222 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...
 
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...
In his circles
121 people
Have him in circles
88 people
ritik Namdev's profile photo
Priyabrat Pattanayak's profile photo
kavita paliwal's profile photo
ALTANAI BISHT's profile photo
Jaibardhan Manu's profile photo
Prince Solomon's profile photo
Sreejith Francis's profile photo
praveen kotte's profile photo
Rana Vishwanath Pratap Singh'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...
 
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...
 
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
In his circles
121 people
Have him in circles
88 people
ritik Namdev's profile photo
Priyabrat Pattanayak's profile photo
kavita paliwal's profile photo
ALTANAI BISHT's profile photo
Jaibardhan Manu's profile photo
Prince Solomon's profile photo
Sreejith Francis's profile photo
praveen kotte's profile photo
Rana Vishwanath Pratap Singh'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