GET SNAPSHOT command

1. 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.

2. 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.

3. 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

4. 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