The object menu allows you to access all of the functions associated with the objects described in the Object browser.  Select the object and then click on the desired command from the Object menu.



Server, Database and Table's functions of the Object menu can also be accessed by right clicking any object in the object browser and selecting any function from the drop-down menu. This process and some functions are described on the Main window page. Please note, that commands are only shown in the menu if they are relevant to the object. Below is the description for all the functions.

Functions specific to Server type:

• Server monitor - allows server monitoring (GP States, Process, Disk Free Space, etc.)
• Server explorer - shows segments and appliances' detailed structure. The left side of the window shows the Segment Servers in the cluster. The right side shows the configuration of each Segment Instance on each Segment Server. The colors help show how the Primary Instances of a server are spread over different Segment Servers. Clicking the node name in the left pane filters the list with segments only to that particular server.
• Open SSH terminal - opens a new window to connect to SSH terminal.
• Refresh - refreshes status of all servers in the object browser.

Functions specific to Database type:

• Refresh Databases - refreshes status of all databases in object browser.
• Copy Database List to Clipboard - copies names of all databases shown in object browser with its size to clipboard.
• Show User Session - brings up a Session List window with a grid showing all users connected to the server.
• Show Query History - shows all executed queries history. This option also allows different setup parameters to be added to the displayed result - can be useful to identify poorly performing queries (Duration column). The Context menu of the query provides you with iterator output of the query. The iterators give you access to more detailed information for the steps of the Explain Plan.
• Change View - changes databases view mode.
• Edit Comment - allows you to make notes of changes and modifications. They are editable via the Workbench and SQL queries.
• Script Database - this option allows you to publish a sql command file with all of the necessary commands to completely rebuild your database structure.You can also customize which objects need should be included in the script.
• Show Tables Size - brings up a new window with detailed description (i.e. Data and Processing Skew) of currently selected database tables.
• Database Maintenance - this brings up a display of all the tables in that database and includes columns that show the Expected Bytes used, Actual Bytes used, Expired Bytes, and the Percent Unused. The Diagnostics Message column gives an indication of the amount of bloat in the table. Tables with high bloat (deleted objects whose space can be reclaimed) can be easily vacuumed right from the menu.

Functions specific to Table type:

• Script - generates basic select, insert, update and DDL commands to either be pasted to to the clipboard for pasting into other programs. The resulting SQL statement can be edited as desired and then executed.
• Data Review - executes a select script requesting the top 100 records.
• Advanced - shows advanced options for selected table (Vacuum and Change Distribution). You can choose one or more of the Available Columns by which to redistribute the table. Selecting multiple columns for a distribution key makes a composite key from those columns.
• Charts - shows frequency distribution chart.
• Edit Comment - makes notes of changes and modifications. Comments are also available for table columns. They are editable via the Workbench and SQL queries.
• Refresh Columns - refreshes columns in the selected table.
• Show Distribution - visualizes how your data is distributed over the SPUs in your system.
• Import/Export Data - imports and exports table from/to external text files. It allows you to customize the operation around the way your data is formatted, including date, null, and binary formatting.

Functions specific to View type:

• Refresh View List - refreshes view list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• Data Review - executes a select script requesting the top 100 records.
• Charts - shows frequency distribution chart. The program will ask you to select a table column for frequency distribution plot.
• Create View - inserts 'Create or Replace View...' SQL command preset to new SQL editor window for fast and easy view creation.
• Edit View - inserts 'Create or Replace View...' SQL command to new SQL editor window with all the data from currently selected view.
• Edit Comment - allows to add/edit description of the selected view.
• Refresh columns - refreshes columns of the selected view.
• Export Data - opens 'Export Data' window, prompting the user to specify different parameters to export the view.

Functions specific to Sequence type:

• Refresh Sequence List - refreshes sequence list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• Edit Comment - allows to add/edit description of the selected sequence.

Functions specific to External Table type:

• Refresh External Table List - refreshes external table list in the selected database.
• Script - generates select, insert statement or DDL commands to either be pasted to the query window or to your clipboard.
• Refresh Column  - refreshes columns of the selected external table.

User Defined Functions:

• Refresh UDF list - refreshes user defined function list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• New - allows you to create a user-defined function. Fill in the 'Function Properties' form, click OK. 
• Edit UDF - allows you to edit a the selected user-defined function.
• Edit Comment - allows to add/edit description of the selected user defined function.

User Defined Aggregates:

• Refresh UDA list - refreshes user defined aggregates list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• New - allows you to create a user-defined function. Fill in the 'Function Properties' form, click OK. 
• Edit UDA - allows you to edit the selected user-defined aggregates.
• Edit Comment - allows to add/edit description of the selected user defined aggregates.

Go up  |  Go To WorkBench Help page