Skip to main content
  • Log in

Menu principal

  • Quienes somos
  • Publicidad y servicios
  • Contact
  • twitter
  • linkedin
  • facebook
Home
  • TOP Software
    • Database
    • Data integration
    • Business intelligence
    • Data Science and AI
    • ERP
    • CRM
    • eMarketing
    • Business management
  • Blogs
  • News and resources

Main tematic navigation

  • Databases
  • Business Intelligence
  • Data Science

Breadcrumb

  1. Home
  2. SQL Tips

Use SYSDUMMY1 in DB2 to obtain the actual server name

By Oscar_paredes on Mon, 11/18/2019 - 08:16
  • Read more about Use SYSDUMMY1 in DB2 to obtain the actual server name
  • Log in to post comments

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

 

Subscribe to SQL Tips

Featured software

Semrush

SemrushSemrush is a web tool for SEO and SEM analysis, focused on the search for keywords (Keyword Research) and competitive analysis.
This web tool, pay per use, provides a user-friendly analysis using data giving access to organic positioning and pay per click for the top 20 positioned keywords in the search…

Promoted Resources

Today's Top Picks for Our Readers:

Recommended by Recommended by NetLine

Suscríbete a nuestro boletín

  • twitter
  • linkedin
  • facebook

Dataprix TOP Technology blogs

Creative Commons License  This work is licensed under a Creative Commons Attribution-Share Alike 4.0 License.

Clear keys input element