Skip to main content

Related Articles

Loading...

IBM iSeries Navigator

DB2 is one of the most popular Database Management System developed by IBM. DB2 is heavily used in various high end applications around the world on mainly AS400 platform. High security, higher performance, easy maintenance and backup/recovery procedure of DB2 are key factors to lead the industry. Even though DB2 is very powerful database management system, it was not very user friendly at early stages. Basically console based programming was required. Most of the users came from Microsoft Windows operating system background don't like to work on console and write everything manually. They always expect some graphical tool to make easy their work. IBM iSeries Navigator full fill this gap effectively and nowadays iSeries Navigator is heavily used desing and program database. Work with iSeries navigator is realy simple as work with Microsoft SQL server UI. iSeries Navigator is client tool that is allowed to work with your DB2 database remotely from your PC. Installing iSeries Navigator is really simple on Microsoft Windows operating system.
You can find iSeries Navigator from "Start -> IBM iSeries Access for Windows -> iSeries Navigator".
Fig 1: Open iSeries Navigator

iSeries Navigator is stand alone windows application which will facilitate almost all the services that can perform in DB2. This is very rich tool but most of the people are still not used effectively.

Fig 2: iSeries Navigator UI

iSeries Navigator main UI containts four major sections and a menu bar. Menu bar is not a complex one and any person can easily work with. Top left hand corner section called "Environment" section and it list down all the entities and services that you can use based on your permission level. Top right hand corner section shows the details for the selected entity of the environment section. "My Tasks" section list down all the possible tasks that can perform at DB2 server level. This list is not unique for all users and will vary based on the permission level that user have. "Environment Tasks" section list down all the task that can perform for the selected environment in environment section.

Common functions listing that can perform using iSeries Navigator is as follows:

  • Design and Create Databases
  • Create Database Schemes
  • Create Tables, Views, Stored Procedures, Functions, Indexes, Triggers and Journals
  • Create Users, User Groups and manage them
  • Manage Security
  • Basic Operations such as Messages, Printer Output, Printers and Jobs
  • Work Management - Manage Jobs, Queues, Subsystems and Memory Pools
  • Network Configuration
  • File System
  • Backup Policies
  • Application Developments

Will discuss one by one further in future articles.

Comments

Post a Comment

Popular posts from this blog

The Power of ChatGPT and Whisper Models

A Deep Dive into Natural Language Processing Natural Language Processing (NLP) has seen a significant boost in recent years due to advancements in artificial intelligence and machine learning. Two models that have shown remarkable success in NLP are ChatGPT and Whisper. In this article, we will delve into the power of these models and their applications in the field of NLP. ChatGPT is a transformer-based language model developed by OpenAI that uses unsupervised learning to predict the next word in a sentence based on the context of previous words. ChatGPT is a generative model that is trained on large datasets of text, such as books and articles, and can be fine-tuned for specific tasks, such as question-answering or dialogue generation. ChatGPT is known for its ability to produce human-like text, making it an ideal tool for applications such as chatbots, content creation, and language translation. Whisper, on the other hand, is a paraphrasing model developed by Google that is based on...
Post a Comment
Read more

PrimeNG UI Components For Angular Application

Getting Started With PrimeNG Styling in Angular App  This chapter we are going to check how you can add PrimeNG card component to show available flowers in the stock. Before styling the app, I have added some images of flowers to our assets folder as below. In app.module.ts file you can import PrimeNG Card module as below. import { BrowserModule } from '@angular/platform-browser'; import { NgModule } from '@angular/core'; import { AppRoutingModule } from './app-routing.module'; import { AppComponent } from './app.component'; import { LandingComponent } from './modules/landing/landing.component'; import { HomeComponent } from './modules/home/home.component'; import { CardModule } from 'primeng/card'; ; @NgModule({   declarations: [     AppComponent,     LandingComponent,     HomeComponent   ],   imports: [     BrowserModule,     AppRoutingModule,     CardModule,        ],   provider...
Post a Comment
Read more

React Hooks

React Hooks revolutionized the way we write components in React by providing a more concise and functional approach to managing state and side effects. In this article, we will explore the basics of React Hooks, their benefits, and how they differ from traditional class components. Whether you're new to React or an experienced developer, understanding Hooks is essential for building modern and efficient React applications. React Hooks are functions that allow you to use state and other React features in functional components. They were introduced in React version 16.8 as a way to write reusable and stateful logic without using class components. Prior to Hooks, stateful logic was typically managed in class components using lifecycle methods such as componentDidMount , componentDidUpdate , and componentWillUnmount . This often led to complex and hard-to-maintain code, especially when dealing with multiple lifecycle methods or sharing stateful logic between components. With React Hook...
Post a Comment
Read more