GET SNAPSHOT command- Cloud DBA

 

GET SNAPSHOT command

The GET SNAPSHOT command collects reputation records and codecs the output. The records this is back is an image of the database supervisor operational reputation on the time which you issued the command.

Scope

This command is issued at the presently connected member and, through default, returns records most effective for that member. In the case of more than one individuals in line with host, the presently connected member is the primary member this is indexed within side the db2nodes.cfg record on that host.

To difficulty the command for a particular member that isn't the presently connected member, specify the ATTACH_MEMBER parameter. To difficulty the command for all individuals and acquire an aggregated result, specify the GLOBAL parameter.

To extrude the presently connected member, difficulty the SET CLIENT command with the ATTACH_MEMBER parameter. You need to difficulty the DETACH command accompanied through the ATTACH command out of your software for this variation to take effect.

Authorization

One of the following authorities:

  • SYSADM
  • SYSCTRL
  • SYSMAINT
  • SYSMON

Command parameters

DATABASE MANAGER

Provides information for the lively database supervisor instance.

ALL DATABASES

Provides widespread information for all lively databases at the modern member.

ALL APPLICATIONS

Provides data approximately all lively programs which can be linked to a database at the modern member.

ALL BUFFERPOOLS

Provides data approximately buffer pool hobby for all lively databases.

APPLICATION APPLID appl-id

Provides data best approximately the utility whose ID is distinct. To get a particular utility ID, use the LIST APPLICATIONS command.

APPLICATION AGENTID appl-cope with

Provides data best approximately the utility whose utility cope with is distinct. The utility cope with is a 32-bit variety that uniquely identifies a utility this is presently walking. Use the LIST APPLICATIONS command to get a particular utility cope with.

FCM FOR ALL MEMBERS

Provides Fast Communication Manager (FCM) information among the member towards which the GET SNAPSHOT command turned into issued and the opposite contributors within side the partitioned database surroundings or in a Db2® pure Scale® surroundings.

LOCKS FOR APPLICATION APPLID appl-id

Provides data approximately all locks held via way of means of the required utility, recognized via way of means of utility ID.

LOCKS FOR APPLICATION AGENTID appl-cope with

Provides data approximately all locks held via way of means of the required utility, recognized via way of means of utility cope with.

ALL REMOTE_DATABASES

Provides widespread information approximately all lively faraway databases at the modern member.

ALL REMOTE_APPLICATIONS

Provides data approximately all lively faraway programs which can be linked to the modern member.

ALL ON database-alias

Provides widespread information and data approximately all programs, tables, desk areas, buffer pools, and locks for a distinct database.

DATABASE ON database-alias

Provides widespread information for a distinct database.

APPLICATIONS ON database-alias

Provides data approximately all programs linked to a distinct database.

TABLES ON database-alias

Provides data approximately tables in a distinct database. This will encompass best the ones tables which have been accessed because the TABLE recording transfer turned into became ON.

TABLESPACES ON database-alias

Provides data approximately desk areas for a distinct database.

LOCKS ON database-alias

Provides data approximately each lock held via way of means of every utility linked to a distinct database.

BUFFERPOOLS ON database-alias

Provides data approximately buffer pool hobby for the required database.

REMOTE_DATABASES ON database-alias

Provides widespread information approximately all lively faraway databases for a distinct database.

REMOTE_APPLICATIONS ON database-alias

Provides data approximately faraway programs for a distinct database.

DYNAMIC SQL ON database-alias

Returns a point-in-time image of the contents of the SQL assertion cache for the database.

DCS

Depending on which clause it's far distinct, this key-word requests information approximately:

-          A particular DCS utility presently walking at the Db2 Connect Gateway

-          All DCS programs

-          All DCS programs presently linked to a particular DCS database

-          A particular DCS database

-          All DCS databases.

AT MEMBER member-variety

Returns outcomes for the member distinct.

GLOBAL

Returns image outcomes for all contributors.

For More Information about Cloud DBA training   Click Here

Contact: +91 9989971070

 

Comments

Post a Comment

Popular posts from this blog

What is UNIX?

Image
  What is UNIX? UNIX is a running gadget which changed into first evolved withinside the 1960s, and has been below regular improvement ever since. By running gadget, we suggest the suite of applications which make the laptop work. It is a stable, multi-person, multi-tasking gadget for servers, computers and laptops. UNIX structures actually have a graphical person interface (GUI) just like Microsoft Windows which gives a clean to apply environment. However, expertise of UNIX is needed for operations which are not protected through a graphical program, or for while there may be no home windows interface available, for example, in a telnet session. Types of UNIX? There are many exclusive variations of UNIX, even though they proportion not unusual place similarities. The maximum famous sorts of UNIX are Sun Solaris, GNU/Linux, and MacOS X. Linux in its flip is packaged in a shape referred to as a Linux distribution. There are numerous Linux distributions, each unfastened and c...
Read more
Image
Disk Partitioning and Mounting File System Creating a partition the use of fdisk surely divides up the gap on a disk. It doesn’t via way of means of itself permit the working machine to save documents there. You first need to create a few infrastructure to maintain content material within the partition; you need to create a File System within the partition. A File System is a manner of storing content material interior a disk partition. There are many sorts of report structures, every with exceptional characteristics. Linux helps a large number. Proprietary working structures usually most effective help their very own kinds of report structures. (Linux can get admission to Linux, Apple, and Microsoft report structures, and dozens of others. Apple can most effective get admission to Apple and Microsoft report structures. Microsoft can most effective get admission to Microsoft report structures – “Does now no longer play properly with others.”) A report machine is the manner the O/...
Read more

Legal Entity creation (Company Creation)

  What Is a Legal Entity? A felony entity is any business enterprise or agency that has felony rights and responsibilities, along with tax filings. It is an enterprise that could input into contracts both as a supplier or a dealer and might sue or be sued in a courtroom docket of law. Legal entities are established in a manner that permits for an extra diploma of safety for strictly private property from complaints and regulatory penalties. Each sort of entity affords a one-of-a-kind set of protections and tax burdens. A felony entity can input into contracts and expect the duties of these contracts, can borrow and pay debts, can record fits and be named with the aid of using different events in fits, and may be held to account for the effects of these complaints. Every felony entity is issued a Legal Entity Identifier (LEI) – a 20-person code that serves as a reference to attach a business enterprise with economic information. LEIs are nonetheless now no longer completely stan...
Read more