DB2 database back up and restore commands and using db2cc tool unix and windows

DB2 database back up and restore commands & using db2cc tool UNIX and windows

This post briefs the steps to take back up of a database in DB2.
There are mutiple ways to take database back up in DB2. I felt the easiest way of taking back up for a database is using the DB2CC tool (DB2 control center tool). There the process or steps to take back up or restore a particular DB is pretty straight and easy.

Yet another simple process to take back up is commands in the command line.

To take back up : 
  db2inst1@nc145016:/opt> db2 BACKUP DATABASE CDSDB TO "/opt/BKP"

                           Backup successful. The timestamp for this backup image is : 20100709051851
However you can see the command generated during the back up taking process using db2cc tool. 
It looks some thing like below ...
-- The following commands may not run as expected in a multi database partition environment if executed from a single script.

-- Quiesce Database
-- Run on any database partition.
CONNECT TO CDSDB;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;

-- Backup Database Partition Grouping 1
-- Run on database partition(s): 0
BACKUP DATABASE CDSDB TO "/opt/BKP" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

-- Unquiesce Database
-- Run on any database partition.
CONNECT TO CDSDB;
UNQUIESCE DATABASE;
CONNECT RESET;

To restore a database : 
A simple command looks like below to restore a particular database.
 db2inst1@nc145016:/opt/BKP> db2 RESTORE DATABASE CDSDB FROM "/opt/BKP" TAKEN AT 20100708081818
                               DB20000I  The RESTORE DATABASE command completed successfully.

And where as the db2cc generated SQL query may look like some thing below 

RESTORE DATABASE CDSDB FROM "/opt/BKP" TAKEN AT 20100708081818 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

Hope this helps .. any related information to db2 database back up / restore process can be posted to this in comments.

Reference : [1] [2] [3]

Read more


Not in Usage for DB2 SQL select subqueries

Here is a sample SQL queries to compare the usage of "NOT IN" in Oracle and DB2..

Usually to filter few rows from the result of one SELECT query we combine another SELECT query with NOT IN phrase.

Example : 1  in Oracle
SELECT * FROM emp WHERE rownum=1 AND rowid NOT IN(SELECT rowid FROM emp WHERE rownum < 10);

Example 2 : in DB2
SELECT FD.SERVER_NAME FROM CDSSCHEMA.DEPOT_SERVER FD where FD.SERVER_NAME NOT IN (SELECT DS.SERVER_NAME FROM CDSSCHEMA.TARGETLIST_MAP TM, CDSSCHEMA.TARGETLIST T, CDSSCHEMA.DEPOT_SERVER DS, CDSSCHEMA.TARGET_SERVER TS WHERE TM.PACKAGE_ID='1278328705570' AND TM.TARGETLIST_ID=T.TARGETLIST_ID AND DS.SERVER_ID=TS.SERVER_ID AND TS.TARGETLIST_ID=T.TARGETLIST_ID ORDER BY DS.SERVER_NAME)

The above query return the list of depot server names which are not in the second select queury.

Read more


shell script to print/check directory permissions on Unix

Shell script to print/check directory permissions on Unix
Here is a small shell script which will print a directory permissions and other details...
Basically I want to check whether a directory has the read write permissions for the user?
I am using here a simple commonsense that a read write permissions will make the octal permissions of it more than 600 for sure .. that's it.
d rwx rwx rwx
d rw- --- ---
   420 000 000
   6     0      0
   rwx r-x r-x
   7 5 5
So it should be always greater than 600 for a directory to have read write permissions always.
Basically I'm using stat tool to find the permissions of a dir
Ex : check stat for /opt/a
nc184120:/opt # stat /opt/a
  File: `/opt/a'
  Size: 48              Blocks: 0          IO Block: 4096   directory
Device: 802h/2050d      Inode: 101912      Links: 2
Access: (0155/d--xr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2010-07-01 22:53:59.845347264 -0700
Modify: 2010-07-01 01:45:43.769709152 -0700
Change: 2010-07-01 01:46:14.790993200 -0700

So the above script doesn't have read or write permissions.

Shell script  :
nc184120:/opt # cat per.sh
dir="/opt/a"
echo "Checking the permissions for $dir"
stat $dir
echo "##############################################"
if [ `stat -c "%a" $dir` -ge 600 ] ; then
     echo "$dir has Read Write permissions."
else
     echo "$dir has no read write permissions."
fi

and the output looks like below ...
nc184120:/opt # ./per.sh
Checking the permissions for /opt/a
  File: `/opt/a'
  Size: 48              Blocks: 0          IO Block: 4096   directory
Device: 802h/2050d      Inode: 101912      Links: 2
Access: (0155/d--xr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2010-07-01 22:53:59.845347264 -0700
Modify: 2010-07-01 01:45:43.769709152 -0700
Change: 2010-07-01 01:46:14.790993200 -0700
##############################################
/opt/a has no read write permissions.


Read more


Vedam - Analysis & Review


The most expected and awaiting movie for me; first time I saw the movie just a little bit ahead from the second half; but second time able to see the full length. overall movie is up to my expectation and it was again a touching story like Krish's debut movie "Gamyam". Many people say "it is experimental" ,"it is a good movie" and "It is challenging" but my feeling is that it is just director's gut feelings and his moral reasons out his life learnings to educate people. The major scenes which moves any of the audience are "Allu arjun trying to rob the money from the old man", "When old man find his money the expressions and the music" and the final scene "When old man pays back the interest amount and patel leaving the kid". Through out the movie I never see Allu arjun, Anushka, Old man or Manchu manoj but just the characters cable raju, Saroja, Ramulu and Vivek(A Typical aspiring rock star) what else as a director krish wants, its purely a directors movie and its a honest success for him.

The noble intention to re-invent the human in all of us by Krish with his "VEDAM" is great. By looking at the trailer it self many wise people predicted the story;  and yes they are correct ! It was a story of five typical different Indians aspiring for different ways in some other way money is the need for most  of them. But I was seriously thinking about Krish; How he manages to score a hit as it is just second movie. Any body by seeing the Anushka in the trailers thinks that movie is fully commercial but krish never gave up his sensitivity to humanism. Prior to the movie release itself people started gossiping about "Vedam"; that the theme behind the movie was terrorism as like "Gamyam" takes theme of Naxalism. But my feeling is "Vedam" is a movie to re-invent the humanism in humans so theme is "Humanism". The patriotism attached to the climax is to high-light the humanism in my feeling. After watching the Prasthanam my only expectation was on "Vedam" and it will be really great if people really watch this movie with true sense of humanism.

Don't know what life lessons impacted krish in his past? the way he pictures the differences between rich and poor in his movies is simply clear and true reflecting the reality. The dialogues about the death people funeral by Allu arjun clarifies the differences between rich and poor.
And many other dialogues are thought provoking ones.
"Perugu vada lo perugu undi kada ani Pulihora lo puli untadaa ??" this dialogue by arjun to Sage(krish was in that role) sound funny but the meaning behind that has so much depth.

"Basti lo pothe ganta lo ettu taaru ; ade akkada chaste rendu rojulu frig lo unchutaaru, manchi gaa chaavalanna dabbu lo puttali ra .."
And coming to songs, all are good Keeravaani surprised me by writing four songs in this movie, and as usual Seetaa rama sastry sirs songs is having so much depth in his lyrics and it is also good.
"Neetho nuvvu kalahisthu
nityam ninu nuvve gelipisthu
samayam pai chirakalam cheragani santakanni pettu "
........

Again hats-off to Sastry sir.

Kudos to krish and his crew.
Special thanks to Allu arjun and Manchu manoj to make it happen ...
P.S : A guest appearance role can have fights, songs and scenes through out the movie and it has impact on climax scene as well. Then what does a real Guest appearance role means. May be manoj did not even tell his name at climax to arjun as his role is guest role.

Read more


Java code to connect DB2 Type 4 driver db2jcc.jar

JAVA sample code to connect to DB2 Database using Type 4 Driver

The below sample code shows the simple way of making connection to a DB2 Server Database exists on a remote machine with out installing any db2 client on your machine. But all we need to have is Type 4 drivers to make this connection which we can use by pointing to the db2jcc.jar and db2jcc_license_cu.jar.
All we need to do is point the java class path to find this jars, in case of eclipse users configure the build path and these 2 jars as external jars from the path they located to the project.   change the Host name, port, user name and password like details in the below program and run accordingly.

Syntax for the connection string : 
 DriverManager.getConnection
                 ("jdbc:db2j:net://<HOSTNAME>:<Port>/<Database name>,"<User name>","<Password>");

Sample connection string :
 DriverManager.getConnection
                 ("jdbc:db2j:net://nc184120.tivlab.austin.ibm.com:50001/CDSDB","db2inst1","db2inst1");

The following is the sample code.... 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Java2DB2 {
public static void main(String[] args)
{
try
{
// load the DB2 Driver
Class.forName("com.ibm.db2.jcc.DB2Driver");
// establish a connection to DB2
Connection db2Conn =
DriverManager.getConnection
("jdbc:db2j:net://nc184120.tivlab.austin.ibm.com:50001/CDSDB","db2inst1","db2inst1");
// use a statement to gather data from the database
Statement st = db2Conn.createStatement();
String myQuery = "SELECT * FROM CDSSCHEMA.ACL_ADMIN";
// execute the query
ResultSet resultSet = st.executeQuery(myQuery);
// cycle through the resulSet and display what was grabbed
while (resultSet.next())
{
String name = resultSet.getString("USER_NAME");
String id = resultSet.getString("USER_ID");
System.out.println("User Name: " + name);
System.out.println("User ID: " + id);
System.out.println("-------------------------------");
}
// clean up resources
resultSet.close();
st.close();
db2Conn.close();
}
catch (ClassNotFoundException cnfe)
{
cnfe.printStackTrace();
}
catch (SQLException sqle)
{
sqle.printStackTrace();
}
}
}


Happy DB2 connectivity :)
Reference : [1]

Read more


XML data to objects/classes JAVA parsing (Data binding - JIBX)

XML file parsing using JIBX tool - XML Data binding to Objects

Some times we may require to parse a given XML file to populate the data in objects.
So here the only source we have is a sample XML file, nothing else not even a xsd file available.
Requirement description :
You are given just one sample XML file which needs to be parsed and populate the data from XML file to java class objects.
There is no XSD (XML schema definition) file available.
Sample XML file contents :

Solution :
 The solution I followed for this is using the jibx tool to reduce the code burden.
 JIBX is one of the best xml parsing tool for xml data binding.

So all we need to do; to use jibx tool we have to do the below mentioned 5 steps.
1. Analyze the sample.xml
2. write the binding.xml.
3. Write the classes identified.
4. Compile using build.xml.
5. Write main method to parse the xml file and show the data.

Analyze the sample.xml :
Read carefully and observe the pattern of data it contains.
Example below
<?xml version="1.0" encoding="UTF-8"?>
<results
        xmlns="urn:www-collation-com:1.0"
        xmlns:coll="urn:www-collation-com:1.0"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="urn:www-collation-com:1.0
              urn:www-collation-com:1.0/results.xsd">

    <ComputerSystem array="1" guid="0A59DB143A8B3B0F9385FE6A3E0BE095" xsi:type="coll:com.collation.platform.model.topology.sys.sun.SunSPARCUnitaryComputerSystem">
        <fqdn>islrpbssn03.in.ibm.com</fqdn>
        <type>ComputerSystem</type>
        <OSRunning guid="8B9EF833438F3F769DF1C6B6F8EB6704" xsi:type="coll:com.collation.platform.model.topology.sys.sun.Solaris">
            <OSConfidence>100</OSConfidence>
            <OSName>SunOS</OSName>
            <OSVersion>5.10</OSVersion>
            <OSMode>64-bit sparcv9 applications,    vis2 vis ,32-bit sparc applications,    vis2 vis v8plus div32 mul32</OSMode>
        </OSRunning>
        <ipInterfaces array="1"
            guid="B0DB02C0C1D03E248FCCF97D3744EFDF"
            lastModified="1270881893121"
            parent="0A59DB143A8B3B0F9385FE6A3E0BE095" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="0188E1E8633E3F5C849E2454ED7F92A2" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="3856A334B3D6306E9A2C5CEC97357808" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="1FF6C43DFD7A3D658939894CD2840FBB" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>9.126.85.190</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="2"
            guid="4CE10626AD1F35879F2BFEFB911C0596"
            lastModified="1270881893058"
            parent="0A59DB143A8B3B0F9385FE6A3E0BE095" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="A5B55BF06F4F3568B0A3A08566776E34" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="C8538176AA8435568BAE99C81BDEFADE" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>127.0.0.1</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
    </ComputerSystem>


    <ComputerSystem array="2" guid="1AE1BAE9EA5F37E3891BA093962E80D2" xsi:type="coll:com.collation.platform.model.topology.sys.linux.LinuxUnitaryComputerSystem">
        <fqdn>islrpbeixn50.in.ibm.com</fqdn>
        <type>ComputerSystem</type>
        <OSRunning guid="70081092A0FB3F3CBF28A93850781F8B" xsi:type="coll:com.collation.platform.model.topology.sys.linux.Linux">
            <OSConfidence>100</OSConfidence>
            <OSName>Linux</OSName>
            <OSVersion>SUSE Linux Enterprise Server 10 (i586)</OSVersion>
            <OSMode>64-bit</OSMode>
        </OSRunning>
        <ipInterfaces array="1"
            guid="C1E26AF496CB3E6898D4C681E7D4890F"
            lastModified="1271145535996"
            parent="1AE1BAE9EA5F37E3891BA093962E80D2" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="BBF92BDB2A9333B999AA5D1F3D2D7DB2" xsi:type="coll:com.collation.platform.model.topology.net.IpV6Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="29D627F80C0635BD9FAD32842E97EC4B" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>0:0:0:0:0:0:0:1</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="2"
            guid="364EF12203853318BCAF2BE2DB279B67"
            lastModified="1271145535918"
            parent="1AE1BAE9EA5F37E3891BA093962E80D2" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="A5B55BF06F4F3568B0A3A08566776E34" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="29D627F80C0635BD9FAD32842E97EC4B" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>127.0.0.1</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="3"
            guid="99FE67EE21B733D18D730D9EB9668D9C"
            lastModified="1271145535964"
            parent="1AE1BAE9EA5F37E3891BA093962E80D2" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="8ABCC5879A4532DFAE9E8341D10F01B6" xsi:type="coll:com.collation.platform.model.topology.net.IpV6Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="802D599BA72A3C84A78B2123F0E6DBB2" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>fe80:0:0:0:20e:cff:fe67:5433</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="4"
            guid="BA733238179833AD91D43E542B9F93CC"
            lastModified="1271145535980"
            parent="1AE1BAE9EA5F37E3891BA093962E80D2" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="DB0FFF95E752314596831ACC9A0FC100" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="802D599BA72A3C84A78B2123F0E6DBB2" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>9.184.66.239</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
    </ComputerSystem>


    <ComputerSystem array="3" guid="5DB5CC25116C39C484C69F4330FEFF86" xsi:type="coll:com.collation.platform.model.topology.sys.aix.AixUnitaryComputerSystem">
        <fqdn>islrpbixv06.in.ibm.com</fqdn>
        <type>ComputerSystem</type>
        <OSRunning guid="6CD3AF45BE603572ABF97B4B1D261D96" xsi:type="coll:com.collation.platform.model.topology.sys.aix.Aix">
            <OSConfidence>100</OSConfidence>
            <OSName>AIX</OSName>
            <OSVersion>5.3.0.0</OSVersion>
            <OSMode>64-bit</OSMode>
        </OSRunning>
        <ipInterfaces array="1"
            guid="E518A4B9197138D0AB7A5671A7897A77"
            lastModified="1270881954418"
            parent="5DB5CC25116C39C484C69F4330FEFF86" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="A5B55BF06F4F3568B0A3A08566776E34" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="2038D4670E123063A7668E8AB92761C2" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>127.0.0.1</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="2"
            guid="ADDB51DDC2B73109ACD8374768D17BBE"
            lastModified="1270881954214"
            parent="5DB5CC25116C39C484C69F4330FEFF86" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="1832ABD3CD2D31E586A8FA14542B5C44" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="3FE22AF17C5F309CAB28E4C3FDBACB76" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="D8AC8F9F2A8433149A5CA169F466AAE4" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>9.122.166.118</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="3"
            guid="529EED8B732333188CFD3490DA1922C5"
            lastModified="1270881953980"
            parent="5DB5CC25116C39C484C69F4330FEFF86" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="BBF92BDB2A9333B999AA5D1F3D2D7DB2" xsi:type="coll:com.collation.platform.model.topology.net.IpV6Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="2038D4670E123063A7668E8AB92761C2" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>0:0:0:0:0:0:0:1</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
    </ComputerSystem>


    <ComputerSystem array="4" guid="6E4C78F0B9463420ADBC21A2658AA22A" xsi:type="coll:com.collation.platform.model.topology.sys.linux.LinuxUnitaryComputerSystem">
        <fqdn>rt4.in.ibm.com</fqdn>
        <type>ComputerSystem</type>
        <OSRunning guid="41693E27B5123A56B946B3DAA7153246" xsi:type="coll:com.collation.platform.model.topology.sys.linux.Linux">
            <OSConfidence>100</OSConfidence>
            <OSName>Linux</OSName>
            <OSVersion>Red Hat Enterprise Linux Server release 5.2 (Tikanga)</OSVersion>
            <OSMode>64-bit</OSMode>
        </OSRunning>
        <ipInterfaces array="1"
            guid="BD81B78B00F431F28E45B9903C673FE4"
            lastModified="1270881834871"
            parent="6E4C78F0B9463420ADBC21A2658AA22A" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="A5B55BF06F4F3568B0A3A08566776E34" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="18F19B1E5BCF33D8B294658B89623E3A" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>127.0.0.1</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="2"
            guid="361035ED31F73386A96E01DB59CF2377"
            lastModified="1270881834761"
            parent="6E4C78F0B9463420ADBC21A2658AA22A" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="D4B04242C8063DD0A15FC4FA539C2886" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="C729C2ED74793124B410B3E08FC4F366" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="F9307994411B350DBCA8C2BD4C983BC8" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>9.184.64.244</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="3"
            guid="618CE77DCA1630728FE9F975F5D92E34"
            lastModified="1270881834839"
            parent="6E4C78F0B9463420ADBC21A2658AA22A" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="BBF92BDB2A9333B999AA5D1F3D2D7DB2" xsi:type="coll:com.collation.platform.model.topology.net.IpV6Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="18F19B1E5BCF33D8B294658B89623E3A" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>0:0:0:0:0:0:0:1</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="4"
            guid="D0C5FD62F70D39D79517C5957A08C012"
            lastModified="1270881835058"
            parent="6E4C78F0B9463420ADBC21A2658AA22A" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="D4E59986D65530F49E2882A857002FF3" xsi:type="coll:com.collation.platform.model.topology.net.IpV6Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="F9307994411B350DBCA8C2BD4C983BC8" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>fe80:0:0:0:250:56ff:feac:255f</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
    </ComputerSystem>


    <ComputerSystem array="5" guid="9AB5DEF9F5FD3DADA2616230B605A250" xsi:type="coll:com.collation.platform.model.topology.sys.linux.LinuxUnitaryComputerSystem">
        <fqdn>rt3.in.ibm.com</fqdn>
        <type>ComputerSystem</type>
        <OSRunning guid="C75FD5FBA18D31C0ADD033BB84254600" xsi:type="coll:com.collation.platform.model.topology.sys.linux.Linux">
            <OSConfidence>100</OSConfidence>
            <OSName>Linux</OSName>
            <OSVersion>Red Hat Enterprise Linux Server release 5.2 (Tikanga)</OSVersion>
            <OSMode>64-bit</OSMode>
        </OSRunning>
        <ipInterfaces array="1"
            guid="006D494967D035D4BE14AB9BA9B35535"
            lastModified="1270881877402"
            parent="9AB5DEF9F5FD3DADA2616230B605A250" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="EDC5FDD18141344E8C38D0634DB3384E" xsi:type="coll:com.collation.platform.model.topology.net.IpV6Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="F739F58377043960813E3F1DFFEF9F79" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>fe80:0:0:0:250:56ff:feac:3d65</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="2"
            guid="934DDB05B9873AE696C77F8AFE6E52A7"
            lastModified="1270881877668"
            parent="9AB5DEF9F5FD3DADA2616230B605A250" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="BBF92BDB2A9333B999AA5D1F3D2D7DB2" xsi:type="coll:com.collation.platform.model.topology.net.IpV6Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="693C859D351830E1AE777C9025B500A6" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>0:0:0:0:0:0:0:1</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="3"
            guid="7A0CAE72A3663716AB1232D870D80EDE"
            lastModified="1270881877589"
            parent="9AB5DEF9F5FD3DADA2616230B605A250" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="A5B55BF06F4F3568B0A3A08566776E34" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="91E4DC01B2B93F1C9733720535C3250A" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="693C859D351830E1AE777C9025B500A6" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>127.0.0.1</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
        <ipInterfaces array="4"
            guid="91CD76C8B641385B97EFA94772ABB624"
            lastModified="1270881877652"
            parent="9AB5DEF9F5FD3DADA2616230B605A250" xsi:type="coll:com.collation.platform.model.topology.net.IpInterface">
            <ipAddress guid="5F42ACC1D9363EB6920C240A4FC1ACE2" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Address"/>
            <ipNetwork guid="C729C2ED74793124B410B3E08FC4F366" xsi:type="coll:com.collation.platform.model.topology.net.IpV4Network"/>
            <l2Interface guid="F739F58377043960813E3F1DFFEF9F79" xsi:type="coll:com.collation.platform.model.topology.net.L2Interface"/>
            <displayName>9.184.64.243</displayName>
            <bidiFlag>3</bidiFlag>
        </ipInterfaces>
    </ComputerSystem>
</results>


binding.xml :
Create binding.xml file by analyzing the given xml file is the crucial part of this solution.
The documentation provided will help in writing binding.xml file for your requirement. see below binding.xml for the above sample.xml. If at all we have xsd file as well it would be easy to write the binding.xml. And we can understand the ways of writing this binding.xml by looking at most possible examples explained in jibx site.

<binding>
    <mapping name="results" class="com.ibm.xmlbind.Results">
        <collection field="computerSystems"
            item-type="com.ibm.xmlbind.ComputerSystem" />
    </mapping>
    <mapping name="ComputerSystem"
        class="com.ibm.xmlbind.ComputerSystem">
        <value name="fqdn" field="fqdn" />
        <value name="type" field="type" />
        <value name="guid" style="attribute" field="guid" />
        <structure name="OSRunning" field="osRunning" usage="optional">
            <value name="OSConfidence" field="osConfidence" usage="optional"/>
            <value name="OSName" field="osName" usage="optional"/>
            <value name="OSVersion" field="osVersion" usage="optional"/>
            <value name="OSMode" field="osMode" usage="optional"/>
        </structure>
        <collection field="ipInterfaces"
            item-type="com.ibm.xmlbind.IPInterfaces" />
    </mapping>
    <mapping name="ipInterfaces" class="com.ibm.xmlbind.IPInterfaces">
        <value name="ipAddress" field="ipAddress" usage="optional"/>
        <value name="ipNetwork" field="ipNetwork" usage="optional"/>
        <value name="l2Interface" field="l2Interface" usage="optional"/>
        <value name="displayName" field="displayName" usage="optional"/>
        <value name="bidiFlag" field="bidiFlag" usage="optional"/>
    </mapping>
</binding>

Creating the classes :
By closely observing the xml file we have to write the classes and their setter and getter methods.
See the classes identified for the above sample.xml below ...

ComputerSystems.java :
package com.ibm.xmlbind;

import java.util.ArrayList;

public class ComputerSystem {

    private String fqdn;

    private String type;

    private String guid;

    private OSRunning osRunning;

    private ArrayList ipInterfaces;

    public String getFqdn() {
        return fqdn;
    }

    public void setFqdn(String fqdn) {
        this.fqdn = fqdn;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public OSRunning getOsRunning() {
        return osRunning;
    }

    public void setOsRunning(OSRunning osRunning) {
        this.osRunning = osRunning;
    }

    public ArrayList getIpInterfaces() {
        return ipInterfaces;
    }

    public void setIpInterfaces(ArrayList ipInterfaces) {
        this.ipInterfaces = ipInterfaces;
    }

    public String getGuid() {
        return guid;
    }

    public void setGuid(String guid) {
        this.guid = guid;
    }

}
IPinterfaces.java:
package com.ibm.xmlbind;

public class IPInterfaces {

    private String ipAddress;

    private String ipNetwork;

    private String l2Interface;

    private String displayName;

    private String bidiFlag;

    public String getBidiFlag() {
        return bidiFlag;
    }

    public void setBidiFlag(String bidiFlag) {
        this.bidiFlag = bidiFlag;
    }

    public String getDisplayName() {
        return displayName;
    }

    public void setDisplayName(String displayName) {
        this.displayName = displayName;
    }

    public String getIpAddress() {
        return ipAddress;
    }

    public void setIpAddress(String ipAddress) {
        this.ipAddress = ipAddress;
    }

    public String getL2Interface() {
        return l2Interface;
    }

    public void setL2Interface(String interface1) {
        l2Interface = interface1;
    }

    public String getIpNetwork() {
        return ipNetwork;
    }

    public void setIpNetwork(String ipNetwork) {
        this.ipNetwork = ipNetwork;
    }

}
OSRunning.java:
package com.ibm.xmlbind;

public class OSRunning {
    private String osConfidence;

    private String osName;

    private String osVersion;
   
    private String osMode;

    public String getOsMode() {
        return osMode;
    }

    public void setOsMode(String osMode) {
        this.osMode = osMode;
    }

    public String getOsConfidence() {
        return osConfidence;
    }

    public void setOsConfidence(String osConfidence) {
        this.osConfidence = osConfidence;
    }

    public String getOsName() {
        return osName;
    }

    public void setOsName(String osName) {
        this.osName = osName;
    }

    public String getOsVersion() {
        return osVersion;
    }

    public void setOsVersion(String osVersion) {
        this.osVersion = osVersion;
    }

    @Override
    public String toString() {
        return "OSConfidence : " + osConfidence + " -- " +
        "OSName : " + osName + " -- " +
        "OSVersion : " + osVersion + " -- " +
        "OSMode : " + osMode;       
    }
   
   

}
Results.java :
package com.ibm.xmlbind;

import java.util.ArrayList;

public class Results {
   
    private ArrayList computerSystems;

    public ArrayList getComputerSystems() {
        return computerSystems;
    }

    public void setComputerSystems(ArrayList computerSystems) {
        this.computerSystems = computerSystems;
    }
   
   
}

Compiling :
once binding.xml and the classes are ready it is required to compile those to map the classes and XML tags.
For compiling this we can use the sample build.xml shown below.
build.xml :
<?xml version="1.0"?>
<project name="xmlbind" default="compile" basedir="..">
    <property name="root-dir" value="${basedir}/Build" />
    <property name="lib" value="${root-dir}/lib" />
    <property name="binding-file" value="${basedir}/binding.xml" />
    <target name="setclasspath">
        <path id="bindpath">
            <pathelement location="${root-dir}" />
            <pathelement location="${basedir}/bin" />
            <pathelement location="${lib}/jibx-bind.jar" />
            <pathelement location="${lib}/bcel.jar" />
            <pathelement location="${basedir}/lib/jibx-run.jar" />
            <pathelement location="${basedir}/lib/xpp3.jar" />
        </path>
    </target>
    <!-- Delete class files for a single example -->
    <target name="clean">
        <delete quiet="true">
            <fileset dir="${basedir}/bin" includes="**/JiBX_*.class" />
        </delete>
    </target>

    <!-- Create Binding classes -->
    <target name="compile" depends="clean,setclasspath">
        <java classname="org.jibx.binding.Compile" fork="yes" dir="${root-dir}" failonerror="true">
            <classpath refid="bindpath" />
            <arg value="${binding-file}" />
        </java>
    </target>
    <!-- Generate classes and binding.xml for given xsd file -->
    <target name="run-bind" depends="setclasspath">
        <java classname="" fork="yes" dir="${root-dir}" failonerror="true">
            <classpath refid="bindpath" />
            <arg value="${binding-file}" />
        </java>
    </target>
</project>


 
Main methods to parse XML file:
The below sample code parses the given XML file and prints the data in the objects.
package com.ibm.test;

import java.io.FileInputStream;

import org.jibx.runtime.*;

import com.ibm.util.Utils;
import com.ibm.xmlbind.*;

public class BindTest {
    public static void main(String[] args) throws Exception {
        IBindingFactory bfact = BindingDirectory.getFactory(Results.class);
        IUnmarshallingContext uctx = bfact.createUnmarshallingContext();
        Results obj = (Results) uctx.unmarshalDocument(new FileInputStream(
                Utils.removeXMLNamespaces("sample.xml")), null);
        for (int i = 0; i < obj.getComputerSystems().size(); i++) {           
            System.out.println("ComputerSystem : " + (i+1));
            System.out.println("--------------------------------------------");
            print((ComputerSystem) obj.getComputerSystems().get(i));
        }
        }
       
   
    private static void print(ComputerSystem sys) {
        System.out.println("  GUID of this Computer system: " + sys.getGuid());
        System.out.println("  fqdn : " + sys.getFqdn());
        System.out.println("  type : " + sys.getFqdn());
        System.out.println("  OSRunning : " + sys.getOsRunning());
       
    }
}
Folder structure in the Eclipse workspace:

Read more

Popular Posts

Enter your email address:

Buffs ...

Tags


Powered by WidgetsForFree