What is a role in Db2?

A role is a database object that groups together one or more privileges and can be assigned to users, groups, PUBLIC, or other roles by using a GRANT statement, or can be assigned to a trusted context by using a CREATE TRUSTED CONTEXT or ALTER TRUSTED CONTEXT statement.

Does SAP use Db2?

Supported IBM Db2 versions SAP certified SAP NetWeaver with the following editions of IBM Db2 on GCP: Db2 Advanced Enterprise Server Edition (AESE) version 11.1 for Linux, UNIX, and Windows. Db2 Advanced Enterprise Server Edition (AESE) version 10.5 for Linux, UNIX, and Windows.

What is DBA cockpit in SAP basis?

The DBA Cockpit is a platform-independent tool that you can use to monitor and administer your database. It provides a graphical user interface (GUI) for all actions and covers many aspects of handling a database system landscape. You access the DBA Cockpit by calling transaction DBACOCKPIT.

What is Db2 database administrator?

Qualifications. Experience administering and migrating DB2 Databases. Provide DB2 Database Administration support. Monitor database performance performed data change requests, migration and database maintenance. Analyze capacity and growth of databases using various automated testing tools and performance optimization.

What is privilege in Db2?

You can control access within Db2 by granting or revoking privileges and related authorities that you assign to authorization IDs or roles. A privilege enables its holder to perform a specific operation, sometimes on a specific object.

What is control privilege in Db2?

The CONTROL privilege: Possessing the CONTROL privilege on an object allows a user to access that database object, and to grant and revoke privileges to or from other users on that object. Note: The CONTROL privilege only applies to tables, views, nicknames, indexes, and packages.

What is db2pd command?

The db2pd -dbptnmem command shows how much memory the Db2 server is currently consuming and, at a high level, which areas of the server are using that memory. Instance memory usage includes not only actual system memory consumption/commitment but also configured allowances that may not be in use/committed.

How do I find the size of a DB2 database in Linux?

How to calculate the size of a DB2 database

1. Connect to the database for which you want to know the size and maximum capacity.
2. Execute the procedure GET_DBSIZE_INFO.
3. Close the connection.

What is Dbacockpit Tcode in SAP?

You can access the DBA Cockpit by calling transaction DBACOCKPIT , or, in the MaxDB/liveCache System Overview (transaction DB59 ) or in the liveCache Assistant (transaction LC10 ), by calling the DBA Cockpit. The splash screen appears DBA Cockpit:Maintaining the System Configuration.

How do I check my DBA cockpit?

Test a DBA Cockpit Configuration

1. From DBA Cockpit, choose System Configuration.
2. Select a system and choose Test Connection. An overview of the servers is displayed.
3. Choose DB Connection Test (All Servers) or select one or more servers and choose DB Connection Test (Selected Servers)

What are the roles and responsibilities of DBA?

DBA Roles and Responsibilities

• Central Control and Coordination.
• The DBA in the IS Organization.
• Establishing Database Control and Administration.
• Data Definition and Control.
• Database Documentation.
• Education and Training.
• The DBA and the User.
• The DBA and Application Selection/Development.

What are DBA responsibilities?

Responsibilities of DBA Makes the decision concerning the content of the database. Plans the storage structure and access strategy. Provides the support to the users. Defines the security and integrity checks.

What is authorization in DB2?

Authorization is the process whereby DB2 obtains information about an authenticated DB2 user that indicates the database operations a user may perform and what data objects may be accessed.

How do I find users in DB2?

To see users in Data Studio expand User branch in Data Source Explorer. To view privilages of user right-click on specific user (1) and then select Properties (2). After it’s done in the bottom of Data Studio will appear Properties tab. Click Privilages (3) and there will be displayed privilages to the database.

What is with grant option in DB2?

When WITH GRANT OPTION is used with PUBLIC, a warning is issued, and the named privileges are granted, but without GRANT authority. If you grant the CREATE_SECURE_OBJECT system privilege, the WITH GRANT OPTION clause is ignored because the CREATE_SECURE_OBJECT system privilege cannot be granted to others.

What is db2pd Db2?

How do I run db2top?

To run in replay mode, db2top must be first run in data collector mode, either in batch mode by running db2top from the command line with the -C parameter, or by activating or deactivating data collection from an interactive session by pressing C. This will create a file

How do I find the size of a DB2 database?

How do I reduce the size of my DB2 database?

You can use any of the following options:

1. ALTER TABLESPACE statement with a REDUCE option. Reduces the Pending free extent.
2. ALTER TABLESPACE statement with a REDUCE option (with size specified) Reduces pending free extents and other free extents by a specified size.
3. ALTER TABLESPACE statement with REDUCE MAX option.

What is RZ20?

RZ20 (CCMS Monitoring) is a standard SAP transaction code available within R/3 SAP systems depending on your version and release level.

What is SAP DB12?

Transaction code DB12 is to collects and presents information that is necessary to monitor database backups. It is an important source of information for the database administrator who has the task of supervising the execution of a defined backup strategy.

How do I add a database to Dbacockpit?

Add a Database Connection

1. From DBA Cockpit, choose DB Connections. An overview of the available database connections for each database platform is displayed.
2. Choose SAP HANA database.
3. Choose Add. The screen DB Connections: Add Connection Entry is displayed.
4. Specify the following information: Option.
5. Save.

What are DB2 locks?

DB2 locks prevent one program from accessing data that has been changed, but not yet committed, by another program. Locking process is controlled by DB2’s IRLM (Inter System Resource Lock Manager). However, whenever practical, DB2 tries to lock pages without going to the IRLM. This type of lock is called a latch.

What is secondary Auth ID in DB2?

Secondary auth IDs enable more than one user to exercise ownership privileges over a group of objects. With secondary Auth IDs, users can easily obtain additional privileges in a DB2 subsystem without these privileges being granted specifically to them.

WHAT IS group in DB2?

DB2 – SQL GROUP BY Statement The GROUP BY statement is used to grouping the rows that have the same values in the table. Grouping lets you divide data into logical sets so that you can perform aggregate calculations on each group. Groups are created using the GROUP BY clause in the SELECT statement.

What is a role in DB2?

DB2 – Roles. Introduction. A role is a database object that groups multiple privileges that can be assigned to users, groups, PUBLIC or other roles by using GRANT statement. Restrictions on roles. A role cannot own database objects. Permissions and roles granted to groups are not considered when you create the following database objects.

What is the role of a DBA?

The DBA is in charge of ongoing maintenance, such as updates and patches. In addition, if a new server is implemented, the DBA is in charge of transferring data from the existing system to the new platform. 2. Managing Data Integrity DBAs primarily handle the overall integrity of a company’s database.

Why do people think DB2 is a speciality?

They think it is a role that can be played by System Administrators or by the people who support or even build applications. Database knowledge, and DB2 in particular is a specialty that can greatly benefit an organization if given enough authority and standing.

What is physical DB2 support?

Physical DB2 Support Physical DB2 support is where I started my career. Larger companies, especially, sometimes divide up DBAs into physical and logical. The physical or systems DBAs are responsible for DB2 fixpacks and upgrades, backup and recovery, regular runstats and reorgs, managing storage and most aspects of database and RDBMS configuration.