Hi everybody,
i would like to set the tables of a tablespace to readonly. I have done the following steps:
1. changed to the directory where the .DAT (Tables) and .INX (indexes) Files are.
2. changed the authorization of .DAT and .INX as follows:
RM and then properties->security-> revoke the permissions "Modify" and "write"
But after this change,...
Maryan
Last Activity: Jul 8 '08, 10:07 AM
Joined: Feb 10 '08
Location:
-
changing the authorization of the tablespace's tables
-
Instead of Trigger
Hi everybody,
i have a view, which contains some columns of two tables. I would like to insert informtions to this view but since this view is created through a join, it is impossible to insert informations to it.
So i decided to use an instead of trigger to do that but i don't know how?
CREATE TABLE Person (
PersonID integer NOT NULL,
Lastname varchar(255)... -
Hello,
thank you for you reply. But change isolation doesn't work when you are connected to the database, does it?
thanks,
Maryan -
changing the Isolation level
Hi everybody,
there are two ways to change the isolation level:
For instance i would like to change the isolation level to rs
1. "db2 change isolation to rs"
2. "db2 set current isolation rs"
When i use the first one and then "db2 values current isolation" to verify if the change was successful, i won't get anything. But when i use the second one and... -
readonly tablespace
Hi everybody,
i have created a tablespace, now i want to change it to readonly. Is it possible to do that in db2 v9. I couldn't find anything about that.
Is it possible to create a readonly tablespace in db2 at all?
Thanks in advance.
Best Regards,
Maryan -
Hello,
thank you for your Reply.
>If you don't want to change it always, then you can go in System Properties--> >environment variables and change the value of this variable.
I knew this way before, but i would like to know the DB2-Command to do like this.
Any help would be appreciated.
Thanks in advance.
MaryanLeave a comment:
-
define another default instance
Hi everybody,
the db2 instance is the default-istance. I would like to change the DB2INSTANCE to another instance (for example to xxx) forever and not to set it only with set DB2INSTANCE=xxx for the current session.
So i tried the following command:
db2set -g db2instdef =xxx;
then i saw through the command db2set -all that the db2instdef is set to xxx But the db2 get instance command gives... -
How to get rid of an uncataloged node??
Hello,
i wanted to catalog a node "lab_node" for an instance "lab" but by mistake i had cataloged a node lab for an instance lab. In order to revoke it, i have uncataloged the node lab and then db2idrop lab.
Then i have created the instance lab and cataloged the node lab_node for instance lab. To control this i have started the Control Center (db2cc) but then i have seen that i have two nodes 1. lab... -
Hello Bernd,
thank you for your answer. That was what i needed.
best regards,
MaryanLeave a comment:
-
connections to a node
Hello,
could any one tell me please how i list out the connections to a node?
thanks in advance.
bye,
Maryan -
Hello,
excuse me for the question. The Statement must be like this:
SELECT IT_BE.Name, (SELECT count(rowNr) from IT_BE) as [count]
FROM IT_BE;
Then it will work.Leave a comment:
-
I am sure that the group by cause the problem but it's impossible to use count without group by.
How can i do that?Leave a comment:
-
Count problem in ACCESS
Hello,
i have used the following statement but the count doesn't return a correct value, could any one help me please.
SELECT IT_BE.Name, Count(IT_BE.row Nr) AS Nr
FROM IT_BE
GROUP BY IT_BE.Name;
I have three records in the table(IT_BE) but i become 1 as Nr instead of 3. What am i doing wrong?
thanks in advance.
Best regards,
Maryan -
Thank you for answering my Question. I have done it like this:
typedef struct
{
char *matrikelnr;
}student;
int main (void)
{
student *studall[2];
char *tVal;
studall[0] = (student*)mallo c(sizeof(studen t));
tVal=(char*)mal loc(10);
strcpy(tVal,"12 345");
studall[0]->matrikelnr =...Leave a comment:
-
pointer to char
Hello,
i have the following code:
typedef struct
{
char *matrikelnr;
}student;
int main (void)
{
student *studall[2];
char tVal[10];
studall[0] = (student*)mallo c(sizeof(studen t));
strcpy(tVal,"12 345");
studall[0]->matrikelnr = tVal;
printf("studall[0]->matrikelnr: %s\n",studall[0]->matrikelnr);...
No activity results to display
Leave a comment: