473,396 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

db2 8.1.5 how obtain machine name

Hi

How obtain server (machine name) with db2 8.1.5 ?
I need get this name in select statement:

select (something)
from sysibm.sysdummy1

Would be nice also obtain fixpack level.

Unfortunnatelly I can't upgrade server and use env_get_sys_infor()
function.

Any hint?
Thanks
Yaro
Oct 19 '06 #1
1 1557
Hi, Yaro.

I'm hopeful that there's yet an easier way, but you may have to roll
your own UDF that calls, say, db2level and/or uname. Check out this
link:

http://www-128.ibm.com/developerwork...303stolze.html

--Jeff

Yaro wrote:
Hi

How obtain server (machine name) with db2 8.1.5 ?
I need get this name in select statement:

select (something)
from sysibm.sysdummy1

Would be nice also obtain fixpack level.

Unfortunnatelly I can't upgrade server and use env_get_sys_infor()
function.

Any hint?
Thanks
Yaro
Oct 19 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: maadhuu | last post by:
hello, i would want to know whether a person can obtain the source code of a c++ program , once he has only the executable with him. ????is that possible ?? as the m/c code is target machine...
3
by: Ed Willis | last post by:
How can I obtain the IP address of the machine that my VB app is running on? Thanks.
4
by: Ed Willis | last post by:
We have several offices that have a DSL or Cable modem where the IP address is dynamic and changes often. I created a VB app that obtains the IP address but it obtains the IP address within the...
5
by: OneFang | last post by:
Hi I hope I make sense here. I want to be able to obtain the name of the method that calls a method within my class. So If I have my class that has a method LogInfo() And my client code...
0
by: Sharan | last post by:
Hi , Could anyone please let me know how to obtain the password complexity of a local machine. I have the foll script: Set usr = GetObject("WinNT://INGBTCPIC5DT440/admin") flag =...
5
by: Bob Alston | last post by:
Can anyone provide an invite or information on how I can obtain a trial version of the newest MS Access software? Bob
8
by: Paul Bromley | last post by:
Thanks for your tolerance on this list. I asked the question regarding Commercial Copy Protection along with Unique PC Idnetifier and obtaining the active IP address. This was all to identify and...
1
by: VictorG | last post by:
Hello, The below C# code works fine in obtaining the windows user's account SID when the user is local to the machine. It throws a "Not Found" exception when trying top obtain the SID for a...
7
by: Brian Cryer | last post by:
What I'm looking for is a way to tell if two sessions are from the same physical PC or from different PCs (within the same organisation say). This is with the view to possibly enforcing license...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.