If you are new to the administration of of Netezza then this is probably the best place to start.
Netezza as it is simply called, is an IBM appliance that is housed in an organisation's data center and unlike Oracle is not an application that is installed on a server as such. Netezza physically comes in the form of some machine that gets placed by IBM's engineers who help you set up the appliance, assign it an IP address and make it available for your users and data warehousing ETL or BI tools to connect to.
Having said that its important to initially describe what Netezza does for you and why it is different and special in its own way. Netezza harnesses a simple logic of "processing close to the data" to give you the results you need from a query in a very quick time. Netezza uses its proprietary technology Asymmetric Massively Parallel Processing (AMPP) to handle complex queries from multiple users.
Common Administrative Tasks:
1. Create Database User
2. Create Database Objects.
3. Groom Database Tables.
4. Form a DR and Backup Strategy
5. Analyse query performance
6. Workload Management.
7.Patch Upgrade and Version Upgrade.
8.Analyse Metadata tables
9. Set us history and query history configurations.
Over my next blog, I will go on explaining the above tasks along with many other useful tricks that may make your life as an administrator simpler.
No comments:
Post a Comment