Record Room modification and Court Room Related Queries

Modify Record Room feature has been depricated now in confonet version later 4.0.

You can use 'Dealing Assistant--->Case Details to modify complainant/respondent related details while if you want to modify court room related details, please use..."Court Room--->Court Room Modification'


Now EA case problem...

              EA case is always filed against a CC disposed case. So select any disposed case and then it will take complainant/Respondent name from that case and then file the case. Later you can modify or add more complainant/respondent through Dealing Assistant.

For any query: Kindly send a mail to confonet-info@nic.in with screen shot and call at 01124305336

Script execution error (At Davangere,karnataka)

If you are not able to run the script using db2 -t -f script.txt then you can run by other way...

Just open script.txt file and copy first SQL Command without semi-column and run as given below...

First go to db2 mode by typeing  db2 and enter...

db2==>

Now if you are getting prompt like given above then paste that SQL command here...
---------------------------------------------------------------------------------------
Example::

db2==> update casefiling set exportflag='N'

(Now you have to run each command one by one...)

If you still have problem then mail to confonet-info@nic.in

Interview Questions: IBM, Nucleous Software for JAVA

Please go for latest interview question in java:::: http://knowledgeserve.blogspot.com

Update case Sequence Number Problem

Update case Sequence Number

If suppose you are getting Case Number like CC/1/2011    or  CC/11/1 and you want to start sequence number from 21, means you want to file a case CC/21/2011(New case Format)  or CC/11/21 (old case format)...

Then Go to Administrator--->Update Case Sequence Number and then choose Consumer Case(CC) and then enter sequence number 20(a integer value not whole case number like CC...) and then submit.

Now the Case will be generated from CC/21/2011.......when you click 'Filing-->Scrutiny & Case Filing'

******Always go for manual from link no 6  http://confonet.nic.in/tsp/tspmanuals.htm

Constraints information in the database catalog in DB2

Table 1. Constraints information in the database catalog

Catalog view	View column	Description	Query example
SYSCAT.CHECKS		Contains a row for each table check constraint	db2 select constname, tabname, text from syscat.checks
SYSCAT.COLCHECKS		Contains a row for each column that is referenced by a table check constraint	db2 select constname, tabname, colname, usage from syscat.colchecks
SYSCAT.COLUMNS	NULLS	Indicates whether a column is nullable (Y) or not nullable (N)	db2 select tabname, colname, nulls from syscat.columns where tabschema = 'DELSVT' and nulls = 'N'
SYSCAT.CONSTDEP		Contains a row for each dependency of a constraint on some other object	db2 select constname, tabname, btype, bname from syscat.constdep
SYSCAT.INDEXES		Contains a row for each index.	db2 select tabname, uniquerule, made_unique, system_required from syscat.indexes where tabschema = 'DELSVT'
SYSCAT.KEYCOLUSE		Contains a row for each column that participates in a key defined by a unique, primary key, or foreign key constraint	db2 select constname, tabname, colname, colseq from syscat.keycoluse
SYSCAT.REFERENCES		Contains a row for each referential constraint	db2 select constname, tabname, refkeyname, reftabname, colcount, deleterule, updaterule from syscat.references
SYSCAT.TABCONST		Contains a row for each unique (U), primary key (P), foreign key (F), or table check (K) constraint	db2 select constname, tabname, type from syscat.tabconst
SYSCAT.TABLES	PARENTS	Number of parent tables of this table (the number of referential constraints in which this table is a dependent)	db2 "select tabname, parents from syscat.tables where parents > 0"
SYSCAT.TABLES	CHILDREN	Number of dependent tables of this table (the number of referential constraints in which this table is a parent)	db2 "select tabname, children from syscat.tables where children > 0"
SYSCAT.TABLES	SELFREFS	Number of self-referencing referential constraints for this table (the number of referential constraints in which this table is both a parent and a dependent)	db2 "select tabname, selfrefs from syscat.tables where selfrefs > 0"
SYSCAT.TABLES	KEYUNIQUE	Number of unique constraints (other than primary key) defined on this table	db2 "select tabname, keyunique from syscat.tables where keyunique > 0"
SYSCAT.TABLES	CHECKCOUNT	Number of check constraints defined on this table	db2 "select tabname, checkcount from syscat.tables where checkcount > 0"

How to see Primary key in a table in DB2

---------See primary key with column name in a table in db2---------------

db2  "select constname,tabname,colname from syscat.keycoluse where tabname='TABLENAME' "

It will give you.....

Example:::  

db2inst1@confonet:~> db2 "select constname,tabname,colname from syscat.keycoluse where tabname='COMPLAINANT_RESPONDENT'"

--------------Output--------------------------------

CONSTNAME                                                                                                                        TABNAME                                                                                                                          COLNAME                                                                                                             
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SQL100416165400090                                                                                                               COMPLAINANT_RESPONDENT                                                                                                           CRSEQ                                                                                                               
SQL100416165400090                                                                                                               COMPLAINANT_RESPONDENT                                                                                                           CR_TYPE                                                                                                             
SQL100416165400090                                                                                                               COMPLAINANT_RESPONDENT                                                                                                           FANO                                                                                                                

  3 record(s) selected.
==========================================================

Here COMPLAINANT_RESPONDENT table have a composite primary key on three column (FANO,CRSEQ,CR_TYPE)

Running Script in DB2

First copy the script (Using WINSCP from client remotely..see screen shot) on server under any directory and then login on server as db2inst1 user through putty remotely from client machine...(You can also do this by accessing server directly)

First give 'ls' command to see whether the script is in current directory or not where you have copied the script on server..

Now connect with your database ... db2 connect to DATABASENAME

And then give command...        db2     -t      -f     script4.txt

Now enter...

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

If this is not working then you have to run each SQL command with out semicolumn (end of each SQL statement in script.txt file)....like this...


db2  "update casetypedocs set mndtstatus='N' where casetypeid=1 "

And then enter..this has to be done for all SQL statements...

If this is also not working then do..
(see below screen)
Type db2 and enter
command  update casetypedocs set mndtstatus='N' where casetypeid=1

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............................

Suse Linux Problems........

1. How to make full permission to a file in Suse Linux..........
2. Access denied, can't create a directory................

Solution: First login as a root user in linux and the go the location where you want to create a directory with full permission:::::

chmod u+rwx,o+rwx,g+rwx DIRECTORYNAME/FILENAME

IBM DB2 commands......

1. How to insert text that contains an apostrophe??

insert into TABLENAME (COLUMN NAME) values('Knowledge''s Power')


Now the output will be like
------------------------
Knowledge's Power

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

2 . How to see tablespaces and containers...........

db2 list tablespaces












-------will give you list of all table spaces.............

db2 list tablespace containers for 2

--------here 2 is the tablespaceID for which you want to see all containers..............

db2inst1@user:~> db2 list tablespace containers for 2

Tablespace Containers for Tablespace 2

Container ID = 0

Name = /home/db2inst1/db2inst1/NODE0000/SQL00039/SQLT0002.0

Type = Path

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

Use of Earth Wire in Current in Home

Ground or earth in a mains (AC power) electrical wiring system is a conductor that provides a low impedance path to the earth to prevent hazardous voltages from appearing on equipment (the terms "ground" (North American practice) and "earth" (most other English-speaking countries) are used synonymously here). Normally a grounding conductor does not carry current.

Neutral is a circuit conductor (that carries current in normal operation), which is connected to earth (or ground) generally at the service panel with the main disconnecting switch or breaker.

In a polyphase or three-wire (single-phase) AC system, the neutral conductor is intended to have similar voltages to each of the other circuit conductors. By this definition, a circuit must have at least three wires for one to serve as a neutral.

In the electrical trade, the conductor of a 2-wire circuit that is connected to the supply neutral point and earth ground is also referred to as the "neutral". This is formally described in the US and Canadian electrical codes as the "identified" circuit conductor.

The NEC and Canadian electrical code only define neutral as the first of these. In North American use, the second definition is used in less formal language but not in official specifications. In the UK the IET definition of a neutral conductor is one connected to the supply system neutral point, which includes both these uses.

All neutral wires of the same electrical system should have the same electrical potential, because they are all connected together through the system ground. Neutral conductors are usually insulated for the same voltage as the line conductors, with interesting exceptions

----------2 G/3G Spectrum Scam---------

It is a term used telecommunication sector. These are radio waves. It is a spectrum which support 2G technology. High bandwidth is required for this purpose. 2G means second-generation wireless telephone technology. Second generation 2G cellular telecom networks were commercially launched on the GSM standard in Finland in 1991.

G has been superseded by newer technologies such as 2.5G, 2.75G, 3G, and 4G; however, 2G networks are still used in many parts of the world.
Three primary benefits of 2G networks over their predecessors were that phone conversations were digitally encrypted; 2G systems were significantly more efficient on the spectrum allowing for far greater mobile phone penetration levels; and 2G introduced data services for mobile, starting with SMS text messages.

knowledgeserve.in

See the new opportunities on our website http://www.knowledgeserve.in

Lesson from 3 idiot movie

3 Idiots- Life’s Learning

1. Never try to be successful , pursue excellence

• Success is the bye product & the result
• Excellence always creates Success & it is a process of continual improvement
• Never run after success
• Let it happen automatically in life

2. Freedom to Life- Life is beautiful

• Don’t die before the actual death
• Live every moment to the fullest as if today is the last day
• Life is gifted to humankind to live
• Live & Live happily towards happiness

3. Passion leads to Excellence

• When your hobby becomes your profession , the passion becomes your profession
• You will be able to lead up to excellence in life
• Satisfaction, Joy, Pleasure & love will be the outcome of the passion
• Following your passion for years , you will surely become somebody one day

4. Learning is very simple- Never stop

• Be humble
• Teachers do fail, Learners never fail
• Learning is never complicate or difficult
• Learning is always possible whatever rule you apply

5. Pressure at head

• Current education system is developing pressure on students head
• University intelligence is useful & making some impact in the life , but it cannot be at the cost of life

6.Life is 6 e s management of emotions & not optimization of intelligence

• Memory and regular study have definite value and it always helps you in leading a life.
• You are able to survive even if you can make some mark in the path of the life.
  
• With artificial intelligence, you can survive & win but you cannot prove yourself genius. Therefore, in this process genius dies in you

7.Necessity is mother of invention

• Necessity creates pressure and forces you to invent something or to make it happen or to use your potentiality.
• Aamir Khan in this film, 3 idiots, is able to prove in the film by using vacuum pump at the last moment

8.Simplicity in life

• Life is need base never want base. Desires have no ends.
• Simplicity is way of life and Indian culture highly stresses on simple living and high thinking, and this is the way of life: ‘Legs down to earth and eyes looking beyond the sky’

9.Industrial Leadership

• Dean of the institute in 3 idiots is showing very typical leadership. He has his own principles, values and ideology, and he leads the whole institute accordingly.
• This is an example of current institutional leadership. In the present scenario, most of the institutes are fixed in a block or Squarish thinking

10.Love is time & space free

• Trust your partner
• Love is not time bound and space bound.
• It is very well demonstrated in this movie same love was demonstrated by Krishna and Meera.
• Love is border free, time free, unconditional and space free.

11.Importance of words in communication

• communication dies, everything dies.
• Each word has impact and value in communication.
• One word if used wrongly or emphasized wrongly or paused at a wrong place in communication what effect it creates and how is it affected is demonstrated very well in this movie.

12.Mediocrity is penalized

• Middle class family or average talent or average institute is going to suffer and has to pay maximum price in the life if they do not upgrade their living standards.
• To be born poor or as an average person is not a crime but to die as an average person with middle class talent is miserable and if you are unable to optimize your potentiality and die with unused potentiality then that is your shameful truth.
• One should not die as a mediocre. He/she has to bring out genius inside him/her
• and has to use his/her potentiality to the optimum level

Seek excellence
&
Success will follow