Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Thu Aug 26, 2004 9:22 am Post subject:
Pzmohanty,
1. Before you issue DB2 commands, run utilities, run application packages and plans, or use most other DB2 functions, you need the appropriate authorization or privilege. For example, to make changes to a table, you need authorization to access that table. A privilege allows an action on an object. For example, to insert data into a table requires the privilege to insert data.
Check this link which explains in detail about data access. Read subtocpics 2.6.4.1.1 & 2.6.4.1.2 in the link below.
2. In DB2, a database is a set of table spaces and index spaces. These index spaces contain indexes on the tables in the table spaces of the same database. Databases are defined using the CREATE DATABASE statement and are primarily used for administration. Whenever a table space is created,it is explicitly or implicitly assigned to an existing database.
Any action you take on a database can be termed as an instance.For example CREATE TABLE statement creates one empty instance of the table, and all application processes
use that one instance of the table.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
