Use SYSDUMMY1 in DB2 to obtain the actual server name

Printer-friendly version
Log in or register to post comments
22 views

By using the auxiliar table sysdummy1 you can query information about a server with DB2 installed.

Next query shows how to obtain the DB2 server name where the session is connected:

SELECT CURRENT SERVER
 FROM SYSIBM.SYSDUMMY1

Most viewed

How to do an update from a select with summarized registers in SQLServer	A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields…
Useful Oracle SQL queries and scripts	Don't you have a chop with useful queries to use in your daily adventures and desventures with the database? I include in this first post a…
Easily export data from Oracle to flat file	A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This…
Avoiding errors concatenating fields with numerical values in SQL Server	The operator to concatenate in SQL Server is '+', but this operator is also used to add values. Being the same operator for both, the…
How to recover the password of the user sa on SQL Server	With SQL Server, when we forget or we lose the password of the DBA user 'sa', and we are the administrators of the database, we have a…
Tips for UPSERT or update using insert in SQL Server	In many cases, especially in ETL processes or data loading to a data warehouse, for example, we would rather use a single sentence or the…
How to connect to a remote MySQL database	MySQL has some special features when making a connection from a remote client that if we do not know can complicate access to a MySQL…
Improve MySQL performance by adjusting some parameters	MySQL, like most database managers, can easily modify the parameters that control memory sizes engaged in certain tasks, resource…
Data Warehouse Security Best Practices	Data warehouse security is vital for organizations that take the huge step of collating all their important data in one place. Unauthorized…
How to connect from Oracle SQL Developer with a remote SQL Server	I tried to create a connection in SQL Developer with a remote SQL Server database.
The Time Dimension Structure and Loading script for SQLServer	In a Data Warehouse there are a number of common dimensions such as Geographic and Time. I leave here a script to create the Time…
Four questions to identify a developer with no knowledge of database	I leave here this link to a page where a small test posed to do in job interviews for database developers. Here this kind of test I do not…
How to disable autocommit option in SQL Server Management Studio	Have you ever wondered how to disable the autocommit option in Sql Server Management Studio? The answer is quick. Simply uncheck the option…
Export data from a SQL Server table	To import and export data from SQL Server, Microsoft provides the tool bpc, which operates by command line. Although it would be…
How to use Openquery to make a join between a SSAS cube and a table from any other database	Imagine you need a report with data from an OLAP sales cube, and have to include data from a table of the relational data source, or from…
Listagg: New Oracle 11.2 function to summarize and aggregate strings	In a LinkedIn debate about how to update from a select with summarized registers in SQL Server, Sergio Romero has shared an interesting…
Slowly Changing Dimensions	Slowly changing dimensions or SCD (Slowly Changing Dimensions) are dimensions in which their data tend to change over time, either…
How to fix broken links with Semrush	The broken external links from our web is a major problem because, besides subtracting useful publication, depending on the importance of…
Defragment to optimize MySQL tables	In MySQL, when you delete records from a table, space is reallocated automatically. It is as empty space and forming new attachments will…
Popular Agile Testing Metrics and KPIs and How to Use Them	Agile test metrics and KPIs are measurements that enable Agile teams to assess how effective their software tests are and whether their…
Oracle 10g: Possible optimization in massive data dump	In batch runs to make a massive data dump into the same table using an INSERT or UPDATE for register within a block, the process can be…
How to access from SQL Server to MySQL databases	We could need to access to MySQL from SQL Server. An easy way to do it is creating a linked server that uses an ODBC connection..
Encrypted Tablespaces in Oracle 11g	Since the release 1 of Oracle 11g, Oracle provides the ability to encrypt tablespaces in full, to protect sensitive data inside and…
SSIS: Workaround to two errors for no apparent reason when we insert data in MySql	For whatever reason we may have to develop a Microsoft Integration Services package we move data from any source to a table that is in a…
Pentaho BI Suite	Pentaho was created in 2004 and at this moment, it is the leader of the Open Source BI solutions. It offers a large spectrum of resources…
Using Machine Learning/AI to Boost the Supply Chain: 5 Use Cases	This article will discuss how supply chains are being improved through the use of innovative technologies before highlighting five uses of…
Oracle10g: Change the character set of the database	It may happen that after you install or configure a new Oracle database we realize that the character set chosen during installation is not…
@ User Manual in Spanish Spoon	Good. I have just completed the update of User Manual in Spanish Spoon @ (See manual..) The manual has been prepared in full, based on the…
MySql: Slow queries, queries to optimize control	In MySQL there is a parameter that enables logging of queries that take more than x seconds to execute calls Slow Queries. Basically what…
Databases designed to handle large volumes	With the growth of the Internet, and most successful web projects, it is increasingly necessary to use scalable databases capable of…