Un-install Confonet Application

Please first login on http://server-ip-address:9060/ibm/console

and then................go to Application-->Enterprises application link


















Now see next screen..select all confonet EAR link and click on un-install button...

















Now Just save this...

You can do fresh installation now.

JNDI name in DB2 Connection

Please see the following screen shots....





































































































Also see other details below on this screen like ip-address of server, database name...according to manual....

Tumkur District Confonet Problem

-----------Problem-------------

-------------------------Solution-------------------

Run following SQL command on your database ....

db2 connect to DATABASENAME

db2 "insert into category values(0,'None')"

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

Send your reply after this....

Confonet Project Details

CONFONET (Computerization and Computer Networking of Consumer Forums in

Country)

Client Government of India

Place National Informatics Centre (NIC), New Delhi

Technologies Java, J2EE, Struts 1.2, DB2 8.2, Linux, WAS(Web Sphere Application Server)

Application Type Web Based (Intranet)

Description: Objectives of CONFONET: To set up Information Communication Technology (ICT) infrastructure at Consumer Redressal forums all over India to provide IT solution at each level in order to provide:

1. E-governance

2. Transparency and efficiency

3. Systematizing of working

To achieve time bound delivery of justice to the consumers.

There are 635 (approx) District forum and 34 state commissions and NCDRC in the country.

Case Monitoring System

Case Monitoring system is an intranet based application to record the proceedings of cases registered by complainants or appellants in consumer courts and provides an easy retrieval of information. Thus the job of monitoring the status of multiple cases as well as maintaining their statistics is highly simplified.

Salient Features

• Automated scrutiny process
• Generates case number automatically
• Reduces the delay in preparation of cause list.
• Helps storage and easy retrieval of judgments.
• Helps to obtain the case status easily.
• Helps litigants to obtain copies of judgment.
• Generates administrative reports for e.g.

==>Particulars of cases filed and pending,

==>Particulars of disposed off cases within 90 days, 90 days to 150 days, Above 150 days.

==> By selecting any duration and state

==> Cases filed, disposed and pending since inception, yearly & quarterly basis.

==> Cases filed, disposed and pending State/District wise.

Linux IP address problem

Question1: How to set ip address in a Linux machine if it's network card is configured...

Answer: First give command to see the network card and default ip address of system...

Login as a root user and then give ifconfig

Now you will get some information

etch0 .....................
.....................
......................

lo ..............
...............

Now give---------------

ifconfig eth0 ip-address netmask 255.255.255.0 up

(This will set the ip-address)

DB2 Problem::: SQL0750N The source table cannot be renamed because it is referenced in a view, materialized query table, trigger, SQL function, SQL m

Problem: SQL0750N The source table cannot be renamed because it is referenced in a view, materialized query table, trigger, SQL function, SQL method, check constraint, or referential constraint...............


Solution: First please see all referential constraint on a table using following command

db2 select constname, tabname, refkeyname, reftabname, colcount, deleterule, updaterule from syscat.references


----------------------------------------------------------
CONSTNAME TABNAME REFKEYNAME REFTABNAME COLCOUNT DELETERULE UPDATERULE
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------- ---------- ----------
--------------------------------------------------------------

Now note down the constant name....say CC1158245432444


Now give command.....

ALTER TABLE TABLE_NAME DROP FOREIGN KEY CC1158245432444;

Now you can rename that table........

DB2 Query::SQL 0973N

Question1::
SQL0973N Not enough storage is available in the "PCKCACHESZ" heap to process the request..


Solution:

1. db2 disconnect DATABASENAME

2. db2 "update db cfg for DATABASENAME using app_ctl_heap_sz 25000"

3. db2 "update db cfg for DATABASENAME using applheapsz 25000"

4. db2 "update db cfg for DATABASENAME using locklist 60000"

5. db2 "update db cfg for DATABASENAME using LOGFILSIZ 10000"



// DATABASENAME is your database name....Please edit these SQL Commands by replacing DATABASENAME with your actual database name


now Go to path
cd /opt/IBM/db2/V8.1/bnd

then run the command as it is.


6. db2 connect to DATABASENAME

7. db2 "bind db2clipk.bnd blocking all grant public clipkg 30"

8. db2 "commit"

Now ........

db2 terminate

db2stop force

db2start

Now you will not find this problem............................