| Author |
Message |
technocrat
*nix forums beginner
Joined: 21 Mar 2006
Posts: 35
|
 Posted: Wed Apr 05, 2006 8:42 pm Post subject:
Re: Is there a way to find the record causing SET INTEGRITY command to fail?
|
|
|
Thanks gert ...I think I would try this first and then try the sql
version of it...if I could get some more info on it , i would
appreciate it.....
The thing i am wndering is...does for exception ....remove only
duplicates?? or remove rows that are violating the FK
constraint...becuase, I am not rteally worried about duplicates...but I
want to find the rows that are violating the FK Constraint...
Any help is appreciated..! |
|
| Back to top |
|
 |
technocrat
*nix forums beginner
Joined: 21 Mar 2006
Posts: 35
|
| Posted: Wed Apr 05, 2006 8:45 pm Post subject:
Re: Is there a way to find the record causing SET INTEGRITY command to fail?
|
|
|
And another thing,...if i user FOr EXCEPTION....if there are violating
rows....then will the status of the table be "C" at the end of SET
INTEGRITY or "N" ...i mean will it be normal or check pending at the
end of Set Integrity ...for exception.....?? |
|
| Back to top |
|
|
Phil Sherman
*nix forums Guru Wannabe
Joined: 16 Jun 2005
Posts: 183
|
| Posted: Wed Apr 05, 2006 9:27 pm Post subject:
Re: Problem inserting spanish characters in DB2 UDB
|
|
|
I've encountered this this problem which is a consequence of using
UTF-8. UTF-8 stores "standard" ascii using one byte per character. When
characters outside of the standard ascii set appear, they are stored as
16 bit unicode, occupying two character spaces. This requires that the
character (preferably varchar) columns be, worst case, defined twice as
large as the number of characters they will contain. Characters in some
languages will occupy more than 16 bits per character, requiring the
column definitions to be larger than two bytes/character.
UTF-8 data in columns also had interesting effects when using db2look to
transfer statistics data to another instance. The high2key and low2key
columns would not correctly transfer if the data values included UTF-8
16 bit characters.
Philip Sherman
pramod wrote:
| Quote: | Hi
I am facing the problem while inserting the spanish characters in the
DB2 UDB v8.2 database. We are pulling the data from SQL server through
informatica and then pushing the same in the DB2 database. Codepage for
DB2 database is UTF-8, which is Unicode. Whenever it is encountering
any spanish charater it is giving the following error:
SQL0302N The value of a host variable in the execute or open statement
is too large for its corresponding use.
SQLSTATE=22001
Please help me.
|
|
|
| Back to top |
|
|
Ian
*nix forums Guru Wannabe
Joined: 02 Aug 2005
Posts: 262
|
| Posted: Wed Apr 05, 2006 9:58 pm Post subject:
Re: Is there a way to find the record causing SET INTEGRITY command to fail?
|
|
|
technocrat wrote:
| Quote: | And another thing,...if i user FOr EXCEPTION....if there are violating
rows....then will the status of the table be "C" at the end of SET
INTEGRITY or "N" ...i mean will it be normal or check pending at the
end of Set Integrity ...for exception.....??
|
Why don't you read the doc for SET INTEGRITY. It will answer all of
your questions. |
|
| Back to top |
|
|
Gert van der Kooij
*nix forums Guru Wannabe
Joined: 27 May 2005
Posts: 267
|
| Posted: Wed Apr 05, 2006 10:09 pm Post subject:
Re: Is there a way to find the record causing SET INTEGRITY command to fail?
|
|
|
In article <44343d0e$1_1@newsfeed.slurp.net>, ianbjor@mobileaudio.com
says...
| Quote: | technocrat wrote:
And another thing,...if i user FOr EXCEPTION....if there are violating
rows....then will the status of the table be "C" at the end of SET
INTEGRITY or "N" ...i mean will it be normal or check pending at the
end of Set Integrity ...for exception.....??
Why don't you read the doc for SET INTEGRITY. It will answer all of
your questions.
|
And to help with that, you can find them at http://tinyurl.com/r7sug |
|
| Back to top |
|
|
technocrat
*nix forums beginner
Joined: 21 Mar 2006
Posts: 35
|
| Posted: Thu Apr 06, 2006 2:25 pm Post subject:
Re: Is there a way to find the record causing SET INTEGRITY command to fail?
|
|
|
hey gert and ian...
I did read thse two docs u both mentioned...I did understand some
stuf..but not really clear...i m trying to implement that and see how
it goes....if i hav eany doubts will get back to you guys ...
thanks again! |
|
| Back to top |
|
|
pukuri
*nix forums beginner
Joined: 06 Apr 2006
Posts: 1
|
| Posted: Thu Apr 06, 2006 3:22 pm Post subject:
Re: Problem with Backup/Restore with Vendore Products
|
|
|
Hi,
nobody has any ideas?
thx
Hannes |
|
| Back to top |
|
|
technocrat
*nix forums beginner
Joined: 21 Mar 2006
Posts: 35
|
| Posted: Thu Apr 06, 2006 7:40 pm Post subject:
Re: Is there a way to find the record causing SET INTEGRITY command to fail?
|
|
|
|
the for exception table worked like a charm..Thanks a ton everyone! |
|
| Back to top |
|
|
Pierre Saint-Jacques
*nix forums Guru Wannabe
Joined: 29 May 2005
Posts: 217
|
| Posted: Thu Apr 06, 2006 10:50 pm Post subject:
Re: Is there a way to find the record causing SET INTEGRITY command to fail?
|
|
|
AFAIK, the SET INTEGRITY command allows you to insert in the exception table
either or both of FK violations and column check violations.
The command has a parm that allows you to specify ALL, CHECK, FK (or
FOREIgn, can't remember).
So the exception table will contain what you'll specify.
Depending on the option, after the set, the table could still be in check
pending. If you use ALL, after the set, the table will be in normal state
and the status will show it.
Look in the SYSCA.TABLES, two columns, STATUS and CONST_CHECKED.
Your docs. will show you that in CONST_CHECKED:
The first Y is indicates the table has been checked for Foreign Key
integrity.
The second Y is indicates the table has been checked for Column Check
integrity.
The fifth Y is indicates the table has been checked for Refresh for MQT
integrity. (Don't ask Y the fifth as opposed to 3rd, 4th ???? I don't know).
As well don't ask Y the rest of the 32 values, I don't know. Maybe it's
like in the docs: This page intentionnally left blank!!!!
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"technocrat" <sumant.kalvala@gmail.com> a écrit dans le message de news:
1144269958.369710.115940@i40g2000cwc.googlegroups.com...
| Quote: | And another thing,...if i user FOr EXCEPTION....if there are violating
rows....then will the status of the table be "C" at the end of SET
INTEGRITY or "N" ...i mean will it be normal or check pending at the
end of Set Integrity ...for exception.....??
|
|
|
| Back to top |
|
|
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Fri Apr 07, 2006 3:09 am Post subject:
Re: re-configuring db2 server for client operation? [comparison to oracle]
|
|
|
"z" <z@y.x.invalid> wrote in message
news:zzkZf.12878$tN3.5191@newssvr27.news.prodigy.net...
| Quote: | I'm sorry I do not know very much about DB2 at all, just
a very superficial amount from running QuickInstall
once.
Would the following be correct [DB2 V 8.2]?
starting from systemA on which DB2 has been installed monolithically
[using the defaults from the Quick Installation Guide wherever possible]
and systemB on which DB2 has not yet been installed:
copy:
systemA /home/dasusr1 to systemB /home/dasusr1
systemA /home/db2fenc1 to systemB /home/db2fenc1
systemA /home/db2inst1 to systemB /home/db2inst1
systemA /opt/IBM to systemB /opt/IBM
systemA /opt/IBMJava2-141 to systemB /opt/IBMJava2-141
[Please let all of the above be a given. Thanks.]
Then, issue the following commands on systemB:
as user db2inst1:
db2 catalog tcpip node systemA remote tcphost server db2c_db2inst1
db2 catalog database sample at node systemA
After this, issuing db2 commands on database sample should not
matter whether the commands are being issues on systemA or systemB.
Correct?
If not, what can be done to the above procedure to make it correct?
[Alternatively, are there files that can be tweaked a la Oracle9i
to achieve the equivalent of the above two db2 administrative commands?]
Thanks...
|
I don't understand what all the copy commands are for. But you cannot
install DB2 or copy a database by copy files. You should do install of DB2,
backup of the database in question, and restore of database on the new
server. Backup and restore are DB2 commands documented in the Command
Reference.
On your first catalog statement: tcphost is the hostname or IP address of
the remote server. db2c_db2inst1 is the port number or service name (as
specified in /etc/services).
On the second catalog statement, you need a database name and an alias name
that the database will be called on the local machine. So it would be
something like:
db2 catalog database sample as sample_r at node systemA authentication
server
sample_r is the alias with a different name in case you have a local
database named sample. But both the database name and alias name can be the
same if it does not already exist. |
|
| Back to top |
|
|
Norbert Munkel
*nix forums beginner
Joined: 30 May 2005
Posts: 41
|
| Posted: Tue Apr 11, 2006 3:02 pm Post subject:
Re: How to recover db2 instance user's privilege?
|
|
|
Mockey Chen schrieb:
| Quote: | I installed a DB2 instance named db2inst1, while the user
db2inst1's DBA privilege revoked by some one by accident.
I want to recove the db2inst1's DBA privilege,
then what should I do?
|
There are three possibilities what might have happened:
1. The user "db2inst1" has been removed from the (operating system)
group configured as SYSADM_GROUP in the database managers configuration.
2. The (operating system) group has been removed.
3. The accident included something like "db2 update dbm cfg using
SYSADM_GROUP=somegroup" and db2inst1 is not member of "somegroup"
Conclusion:
1.
If you can still remember which group was configured as "SYSADM_GROUP",
just add db2inst1 to that group (create the group if necessary, eg
db2iadm1). Unfortunately "get dbm cfg" will not work to figure that out
due to limited privileges.
OR
2.
Drop the instance, recreate it and catalog your databases again.
Restoring them should not be necessary (although a fresh backup always
gives a better feeling).
Hint: db2cfexp and db2cfimp are very nice tools to backup/restore and
even edit the (instance)-configuration.
regards,
Norbert |
|
| Back to top |
|
|
Norbert Munkel
*nix forums beginner
Joined: 30 May 2005
Posts: 41
|
| Posted: Wed Apr 12, 2006 10:13 am Post subject:
Re: How to recover db2 instance user's privilege?
|
|
|
Hi again,
Mockey Chen wrote:
| Quote: | I re-create the instance, and how to know the database name through
the DB2 data directory?
|
Well, you should at least remember which database you are missing. E.g.
If it was "test" something like
db2 catalog database test
should do.
If you _really_ can't remember the missings database Name, a look at the
name of the corresponding Backup-Image should help.
Best regards,
Norbert |
|
| Back to top |
|
|
Darin McBride
*nix forums Guru Wannabe
Joined: 28 Jul 2005
Posts: 100
|
| Posted: Tue May 23, 2006 3:45 pm Post subject:
Re: Does DB2 8.2 Enterprise Edition support IPv6?
|
|
|
Mockey Chen wrote:
| Quote: | Does DB2 8.2 Enterprise Edition support IPv6?
|
IPv6 support should be in the Viper beta available on IBM's website. |
|
| Back to top |
|
|
Jan M. Nelken
*nix forums Guru Wannabe
Joined: 26 May 2005
Posts: 126
|
| Posted: Mon May 29, 2006 4:48 pm Post subject:
Re: DBA Interview Questions
|
|
|
rmli wrote:
Please try to comprehend that Oracle and DB2 do differ...
Jan M. Nelken |
|
| Back to top |
|
|
Knut Stolze
*nix forums Guru
Joined: 28 Jul 2005
Posts: 755
|
| Posted: Tue Jun 13, 2006 8:09 am Post subject:
Re: Installing probs with DB2 universal Database 8.2
|
|
|
Photubias wrote:
| Quote: | On 1 machine the installation works perfectly with one of the first
installations screens being the one with the Typical installation taking
520-590MB.
But on about 5 other machines i wanna do exactly the same, but then i get
the installation screen with Typical installation taking 10-20MB. Here the
installation failes eventually, does any one have seen this? And is there
a simple solution?
|
Maybe you don't even try to install the same product, e.g. server vs.
client-only?
Also what does "installation fails" actually mean? Some sort of error
message? If so, which?
--
Knut Stolze
DB2 Information Integration Development
IBM Germany |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
