Bytes - answers

Create db2 table directly by importing flat file without prior db2 table existing

raka61 — Tue, 17 Nov 2009 11:34:31 GMT

Hi ,

I need help in understanding if i can directly(there are 100s of different structured files i get in text format with & hence dont wnat to manually define the structure for each file manually) create a db2 table with the structure & data as in excel or flat file by importing the flat file .I have only DB@ enterprise server.No other tools....DTS in MS SQL saves this complete effort(even if it means all fields are varchar...it still recognizes all column names from the flat file automatically.

Getting Error sql0338n

tejasmore — Mon, 16 Nov 2009 08:52:43 GMT

Hi,
I am running a following query in DB2 and getting SQL0338n error.
This is primarily because, there are subqueries at few places (marked in bold)in the main query, after 'ON' clause.
Could anyone please help me, as how these subqueries can be replaced without change in resultset?

Thanks,
Tejas.

--------------------------------------------------------------------------------
Select
.
.
.
FROM join_is JID
LEFT OUTER JOIN AD_PH ph
ON JID.h_num=ph.h_num
AND JID.ph_ts=ph.ts
LEFT OUTER JOIN AD_COM cmd
ON ph.cmd_cd = cmd.cmd_cd
AND cmd.ts =
(
SELECT max(ts)
FROM AD_COM cmd_sub
WHERE cmd_sub.v_frm <= @start
AND cmd_sub.cmd_cd = ph.cmd_cd
) LEFT OUTER JOIN AD_PS ps
ON JID.p_num=ps.p_num
AND JID.ps_ts=ps.ts
LEFT OUTER JOIN PSM
ON JID.p_num=PSM.p_num
LEFT OUTER JOIN AD_FORM af
ON JID.h_num = af.h_num
AND af.ts =
(
SELECT max(ts)
FROM AD_FORM af_sub
WHERE af_sub.v_frm <= @start
AND af_sub.h_num = JID.h_num
) LEFT OUTER JOIN AD_FC afc
ON JID.h_num = afc.h_num
AND afc.ts =
(
SELECT max(ts)
FROM AD_FC afc_sub
WHERE afc_sub.v_frm <= @start
AND afc_sub.h_num = JID.h_num
),
AD_PCR pcr
LEFT OUTER JOIN
(
SELECT sub_p.ps_num AS m_ps_num, max(f_pr_dt) AS match_f_pr_dt
FROM AD_PCR sub_p, PSM ps_ids
WHERE sub_p.ps_num = ps_ids.ps_num
AND sub_p.ts =
(SELECT MAX(ts) FROM AD_PCR sub_p2 WHERE sub_p2.p_num = sub_p.p_num AND sub_p2.v_frm < @end)
AND sub_p.ad_ty_ind != 'D'
AND sub_p.td_st_ind != 'C'
GROUP BY sub_p.ps_num
HAVING MAX(sub_p.f_pr_dt) <= @start
) match ON match.m_ps_num = pcr.ps_num
LEFT OUTER JOIN #efp efp ON efp.p_num = pcr.p_num
LEFT OUTER JOIN AD_BD bd
ON bd.p_num IN
(
SELECT head_bd.p_num
FROM AD_BD head_bd
WHERE head_bd.bd_num = pcr.bd_num
AND head_bd.ts =
(
SELECT max(ts)
FROM AD_BD head_bd_sub
WHERE head_bd_sub.v_frm <= @start
AND head_bd_sub.bd_num = head_bd.bd_num
)
)AND bd.ts =
(
SELECT max(ts)
FROM AD_BD bd_sub
WHERE bd_sub.v_frm <= @start
AND bd.bd_num = bd_sub.bd_num
)
AND bd.pump_dt IS NOT NULL
AND bd.ad_ty_ind != 'D'
AND NOT EXISTS
(
SELECT 1
FROM AD_BD bd_sub2
WHERE bd_sub2.p_num = bd.p_num
AND bd_sub2.ts != bd.ts
AND bd_sub2.ad_ty_ind != 'D'
AND
(
bd_sub2.pump_dt IS NULL
OR (bd.pump_dt <= bd.v_frm AND bd_sub2.ts > bd.ts)
OR (bd.pump_dt > bd.v_frm AND (bd_sub2.pump_dt > bd.pump_dt OR bd_sub2.v_frm > bd.pump_dt))
)
AND bd_sub2.ts =
(
SELECT max(ts)
FROM AD_BD bd_sub3
WHERE bd_sub3.v_frm <= @start
AND bd_sub3.bd_num = bd_sub2.bd_num
) )
LEFT OUTER JOIN AD_CNT cntr
ON pcr.cnt_num = cntr.cnt_num
AND cntr.ts =
(
SELECT max(ts)
FROM AD_CNT cntr_sub
WHERE cntr_sub.v_frm <= @start
AND cntr_sub.cnt_num = pcr.cnt_num
)

How to get the stored procedure information?

srilata83 — Tue, 10 Nov 2009 09:09:06 GMT

Hi All,

I dont know much about stored procedure.I am being asked to increase the ASUTIME LIMIT parameter .I know that to alter the parameter. i have to get the stored procedure and from there only i can alter the parameter.But the requesting team doesnt know where to get stored procedure name.Do anybody help?Or is there any other way to increase this Limit?The job is a db2 unload utility.Hw can i alter this limit and how to get the stored proc name?

Please help.....

Thanks in advance.

hw to get the stored procedure information?

srilata83 — Tue, 10 Nov 2009 08:54:38 GMT

Hi All,

I am being asked to increase the ASUTIME LIMIT
parameter .I know to alter the parameter. i have to get the stored procedure and from there only i can alter the parameter.But the requesting team doesnt know where to get stored procedure name.Do anybody help?Or is there any other way to increasse this Limit?

Thanks in advance.

Db2cmd error

Azahary — Thu, 05 Nov 2009 04:24:10 GMT

Hi,

I'm using DB2v8.1.7 on window XP. I got

DB2CMD.EXE -> 5
SQL1042C An unexpected system error occurred.

when try to execute DB2 command on CLP.

Is there any solution for this problem ? Thank you very much in advance.

Regards
Azahary

MQT with MQT

sivuj18 — Mon, 02 Nov 2009 06:49:07 GMT

Hi,

I am using DB2 UDB 9.1, today i tried to create an MQT using another MQT.

For example : create table mqt_test as (select col1,col2 from mqt1) data initially deferred refresh deferred;

In the above statement mqt1 is one MQT created in my db, now i am trying to create another mqt i.e, mqt_test on top of it.

Is it possible to create like this because Oracle Mat views supports this, but i dont know about DB2. Can any one suggest me on this.

Thanks,
Siva

Performance Problem with Order by Clause in DB2

gecashish — Fri, 30 Oct 2009 16:59:38 GMT

If i use below query
Select * from ADJ_ADJSTMNT fetch first 21 rows only with ur;
works fine
But if i use the same query with order by clause like below
Select * from ADJ_ADJSTMNT
order by adj_ca_id
fetch first 21 rows only with ur;

It's very much time consumming.
Pls note that ADJ_ca_id has an primary index,It's must for me to select all records from ADJ rather then some specific fields from ADJ

What could be the possible solutions.

Many Thanks in Advance

BAckup online with include logs fails !!!

alex250374 — Fri, 30 Oct 2009 08:35:44 GMT

Hi all,

db2 9.1 fixpak 0
aix 5.3

I have a big problem every time I start an online backup with include logs via veritas comes out an error!!!
The db2diag shows:
2009-10-29-17.57.22.240269+060 E10634592A396 LEVEL: Info
PID : 995458 TID : 1 PROC : db2agent (idle)
INSTANCE: db2inst1 NODE : 000 DB : ATMDB
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1391
MESSAGE : Starting an online db backup.

2009-10-29-18.34.34.020288+060 I10634989A414 LEVEL: Warning
PID : 1253454 TID : 1 PROC : db2logmgr (ATMDB)
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpReadFromVendorDevice, probe:1240
MESSAGE : Return code from sqlpReadFromVendorDevice:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD010 : 0000 0019 ....

2009-10-29-18.34.34.021707+060 I10635404A288 LEVEL: Error
PID : 1253454 TID : 1 PROC : db2logmgr (ATMDB)
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogVendor, probe:3720
RETCODE : ZRC=0x00000019=25

2009-10-29-18.34.34.961017+060 I10635693A401 LEVEL: Error
PID : 983148 TID : 1 PROC : db2lfr (ATMDB)
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, recovery manager, sqlplfrOpenExtentRetrieve, probe:225
MESSAGE : Received error from db2logmgr on retrieve:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD260 : 0000 0019 ....

2009-10-29-18.34.34.961173+060 I10636095A442 LEVEL: Error
PID : 647378 TID : 1 PROC : db2bm.995458.1
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
FUNCTION: DB2 UDB, data protection services, sqlpOpenLogForBackup, probe:20
RETCODE : ZRC=0x82100016=-2112880618=SQLPLFR_RC_RETRIEVE_FAILED
"Log could not be retrieved"

2009-10-29-18.34.34.967397+060 E10636538A491 LEVEL: Error
PID : 647378 TID : 1 PROC : db2bm.995458.1
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent, probe:1855
MESSAGE : ADM8010E Backup was unable to copy requested log file "S0004615.LOG"
for inclusion in the backup image. The backup has been aborted.

2009-10-29-18.34.34.967558+060 I10637030A385 LEVEL: Error
PID : 647378 TID : 1 PROC : db2bm.995458.1
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
MESSAGE : Current extent:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFF6A58 : 0000 1207 ....

2009-10-29-18.34.34.967677+060 E10637416A483 LEVEL: Severe
PID : 647378 TID : 1 PROC : db2bm.995458.1
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent, probe:1910
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2428
DATA #2 : Hexdump, 4 bytes
0x000000011127E840 : FFFF F684 ....

2009-10-29-18.34.34.967828+060 E10637900A886 LEVEL: Severe
PID : 647378 TID : 1 PROC : db2bm.995458.1
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent, probe:1910
MESSAGE : SQL2428N The BACKUP did not complete because one or more of the
requested log files could not be retrieved.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2428 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlubPro
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2009-10-29-18.34.34.968773+060 E10638787A473 LEVEL: Severe
PID : 647378 TID : 1 PROC : db2bm.995458.1
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, sqlubbuf, probe:338
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2044
DATA #2 : Hexdump, 8 bytes
0x000000011127E840 : FFFF F804 0000 0002 ........

2009-10-29-18.34.34.968905+060 E10639261A872 LEVEL: Severe
PID : 647378 TID : 1 PROC : db2bm.995458.1
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, sqlubbuf, probe:338
MESSAGE : SQL2428N The BACKUP did not complete because one or more of the
requested log files could not be retrieved.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2428 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlubPro
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2009-10-29-18.34.39.978211+060 I10640134A664 LEVEL: Error
PID : 1118270 TID : 1 PROC : db2med.995458.0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:939
DATA #1 : String, 110 bytes
Vendor error: rc = 17 returned from function sqluvend.
Return_code structure from vendor library nbdb2.sl64:

DATA #2 : Hexdump, 48 bytes
0x0FFFFFFFFFFFD858 : 0000 020C 4E65 7442 6163 6B75 7020 436F ....NetBackup Co
0x0FFFFFFFFFFFD868 : 6D6D 6974 2041 6374 696F 6E20 4661 696C mmit Action Fail
0x0FFFFFFFFFFFD878 : 6500 08BA 18A8 08BA 0000 0000 0000 0000 e...............

2009-10-29-18.34.39.978615+060 I10640799A313 LEVEL: Warning
PID : 1118270 TID : 1 PROC : db2med.995458.0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMCTerminateBackup, probe:1322
MESSAGE : Media controller -- Problem closing vendor device

2009-10-29-18.34.39.983990+060 E10641113A708 LEVEL: Error
PID : 995458 TID : 1 PROC : db2agent (idle)
INSTANCE: db2inst1 NODE : 000 DB : ATMDB
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, sqlubCleanupPartialBackup, probe:578
MESSAGE : Error returned by sqluvdel
DATA #1 : unsigned integer, 4 bytes
26
DATA #2 : Hexdump, 48 bytes
0x0FFFFFFFFFFE4A68 : 0000 01F9 4E65 7442 6163 6B75 7020 4442 ....NetBackup DB
0x0FFFFFFFFFFE4A78 : 3220 496E 7075 7420 496E 7661 6C69 6400 2 Input Invalid.
0x0FFFFFFFFFFE4A88 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2009-10-29-18.34.39.990737+060 E10641822A374 LEVEL: Severe
PID : 995458 TID : 1 PROC : db2agent (idle)
INSTANCE: db2inst1 NODE : 000 DB : ATMDB
APPHDL : 0-692 APPID: *LOCAL.db2inst1.091029165722
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:850
MESSAGE : Backup terminated.

Attach the db_cfg.

Backup command is:

db2 online backup db dbname online load / usr/openv/netbackup/bin/nbdb2.sl64 inlude logs
Help me please...

Attached Files

db_cfg.txt (6.8 KB)

How to write a stored procedure?

nityanandkore — Mon, 26 Oct 2009 09:40:41 GMT

Hi all,
I m As/400 user. I wan to know how to write a stored procedure in as/400 db2 and how compile/run it?
Please reply me urjently... I m in urjentl need of it...

Thanks in Advance,
Nityanand.

locks, transactions and stored procedures

forumwebuser — Thu, 22 Oct 2009 17:33:54 GMT

hello,

Im calling a db2 sp from a java application. Im not declaring explicitly any transaction at client side.

The stored procedure has a configuration like the following. There is no explicit transaction declared inside the SP as well.

Run_some_code_area1
Select statement to row_xy
Run_some_code_area2
an Update statement to row_xy (the same from the select statement)
Run_some_code_area3

Now, imagine there are two application invoking this same SP, an that each one will try to select and update exactly the same row: row_xy. If application_A is in the Run_some_code_area2 block, will Application B be able to execute with sucess the select statement?

Thank you

Return union result in one row?

pppat — Thu, 22 Oct 2009 12:47:07 GMT

Hi folks,

I want to union two tables into one row per empno

SELECT EMPNO, EMAIL , ' '
FROM EMP_T

UNION ALL
SELECT EMPNO, ' ', MGREMAIL
FROM MGR_T

tables look like this:

EMP_T

EMPNO EMAIL
------- ----------
0001 emp1@123.com
0002 emp2@123.com
0003 emp3@123.com

MGR_T

EMPNO MGREMAIL
------- -----------------------------
0001 mgr1@123.com
0002 mgr2@123.com
0004 mgr3@123.com
0003 mgr4@123.com

I want the result to look like this:

EMPNO email mgremail
------- -------------------- --------------------
0001 emp1@123.com mgr1@123.com
0002 emp2@123.com mgr2@123.com
0004 mgr3@123.com
0003 emp3@123.com mgr4@123.com

Any suggestions ?
Thanks

SQL1336N and DB2 CONNECTIVITY PROBLEM. What am I doing wrong?

okonita — Thu, 22 Oct 2009 03:47:52 GMT

Hi all,

I am having a DB2 connectivity problem that I hope someone can help me resolve. I need this to test Replication and such other things. What am I doing wrong here? Any help that
I can get will be highly appreciated.

First, the error that I am getting when I try to connect to the remote host after performing NODE and database catalog is the following:

[IBM][CLI Driver] SQL1336N The remote host "WINSVR2008R2-2" was not found. SQLSTATE=08001. I have reviewed the associated explanation for the SQL1336N error message which in
essence states that the system cannot resolve the IP address of the remote host.

For further clarification, I have DB2 Express-C 9.7 installed on my Vista Home premium Laptop. I also have VMware Workstation 6.5.3 hosting Windows Server 2008 R2 as guest OS.
On this Windows Server 2008 R2 is installed a copy of DB2 Express-C 9.7. I desire connectivity to this DB2 copy from my Vista machine's DB2 Control Center. Below is what I have
configured for my local and remote DB2 environment.

Please take note of what I have for IP address from issuing IPCONFIG for both VISTA host and the VMware Windows Server 2008R2:

(1) From the Services file on both environment (Vista and Windows Server2008R2) I have:

SERVICE NAME PORT#

db2vistaj_DB2 55000/tcp #HomeLaptop-1 <---- Vista Home Premium - Local Machine
db2vista_DB2 50000/tcp #HomeLaptop-1

db2j_DB2T0 65000/tcp #Windows Server 2008 R2 TestBaseVM <---- VMware/Windows Server 2008 R2 (Remote). Cataloged locally
db2c_DB2T0 60000/tcp #Windows Server 2008 R2 TestBaseVM

db2j_DB2W0 55000/tcp #Windows Server 2008 R2 WorkBaseVM <---- Another VMware/Windows server 2008 R2. This is not currently cataloged on my local machine
db2c_DB2W0 50000/tcp #Windows Server 2008 R2 WorkBaseVM local machine (Remote)

Catalog Information:

cATALOG TCPIP NODE SVR2008A REMOTE WINSVR2008R2-2 SERVER db2c_DB2T0 OSTYPE WIN

CATALOG DATABASE SAMPLE AS SAMPLEA AT NODE SVR2008A

db2 => list node directory

Node Directory

Number of entries in the directory = 1

Node 1 entry:

Node name = SVR2008A
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = WINSVR2008R2-2
Service name = db2c_DB2T0

db2 => list database directory

System Database Directory

Number of entries in the directory = 3

Database 1 entry:

Database alias = TOOLSDB
Database name = TOOLSDB
Local database directory = C:
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = SAMPLEA
Database name = SAMPLE
Node name = SVR2008A
Database release level = d.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

Database 3 entry:

Database alias = SAMPLE
Database name = SAMPLE
Local database directory = C:
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

------------------------------------------------------------------------------------------------------------------------------------------------------

IPCONFIG -- WINDOWS SERVER 2008 R2

C:\Users\Administrator>ipconfig /all

Windows IP Configuration

Host Name . . . . . . . . . . . . : WINSVR2008R2-2
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No

Ethernet adapter Local Area Connection* 9:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Microsoft Failover Cluster Virtual Adapte
r
Physical Address. . . . . . . . . : 02-0C-29-6E-50-FB
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Intel(R) PRO/1000 MT Network Connection
Physical Address. . . . . . . . . : 00-0C-29-EF-CE-93
DHCP Enabled. . . . . . . . . . . : No
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::fc5c:9725:716c:6c50%11(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.2.2(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.2.1
DHCPv6 IAID . . . . . . . . . . . : 234884137
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-12-6D-E2-CA-00-0C-29-6E-50-FB

DNS Servers . . . . . . . . . . . : 192.168.2.1
NetBIOS over Tcpip. . . . . . . . : Enabled

IPCONFIG -- VISTA (HOST and Showing, Wireless Network Connection, VMware Network Adapter VMnet1 and VMnet8)

C:\Users>IPCONFIG /ALL

Windows IP Configuration

Host Name . . . . . . . . . . . . : HomeLaptop-1
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : Belkin

Wireless LAN adapter Wireless Network Connection:

Connection-specific DNS Suffix . : Belkin
Description . . . . . . . . . . . : Atheros AR5007 802.11b/g WiFi Adapter
Physical Address. . . . . . . . . : 00-23-4D-B5-17-89
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::54a1:eaaf:3842:591c%11(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.2.2(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Lease Obtained. . . . . . . . . . : Wednesday, October 21, 2009 9:35:53 PM
Lease Expires . . . . . . . . . . : Friday, October 19, 2018 9:35:53 PM
Default Gateway . . . . . . . . . : 192.168.2.1
DHCP Server . . . . . . . . . . . : 192.168.2.1
DHCPv6 IAID . . . . . . . . . . . : 234890061
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-12-62-44-FB-00-23-4D-B5-17-89

DNS Servers . . . . . . . . . . . : 192.168.2.1
192.168.2.1
NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Local Area Connection:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Realtek RTL8102E Family PCI-E Fast Ethern
et NIC (NDIS 6.0)
Physical Address. . . . . . . . . : 00-1E-EC-B7-40-15
DHCP Enabled. . . . . . . . . . . : No
Autoconfiguration Enabled . . . . : Yes

Ethernet adapter VMware Network Adapter VMnet1:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : VMware Virtual Ethernet Adapter for VMnet
1
Physical Address. . . . . . . . . : 00-50-56-C0-00-01
DHCP Enabled. . . . . . . . . . . : No
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::71e1:6dac:8abe:3e46%12(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.233.1(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
DHCPv6 IAID . . . . . . . . . . . : 369119318
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-12-62-44-FB-00-23-4D-B5-17-89

DNS Servers . . . . . . . . . . . : fec0:0:0:ffff::1%1
fec0:0:0:ffff::2%1
fec0:0:0:ffff::3%1
NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter VMware Network Adapter VMnet8:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : VMware Virtual Ethernet Adapter for VMnet
8
Physical Address. . . . . . . . . : 00-50-56-C0-00-08
DHCP Enabled. . . . . . . . . . . : No
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::35cc:4e5d:6032:35dd%13(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.139.1(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
DHCPv6 IAID . . . . . . . . . . . : 402673750
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-12-62-44-FB-00-23-4D-B5-17-89

DNS Servers . . . . . . . . . . . : fec0:0:0:ffff::1%1
fec0:0:0:ffff::2%1
fec0:0:0:ffff::3%1
NetBIOS over Tcpip. . . . . . . . : Enabled