Why would be intensive ?
When I add row to maintable DB engine check if value in the "City" column
exist in the view. If exist - do nothing. If no - add value to the view.
But with deletion we must check existance any other row
with same "City" and delete city from view only when no row
with...
I know about "select distinct". But it is VERY resource consumption action.
Of course, I may make "view functionality" by myself with two tables
and foreign key, but it's DB's duty I mean.
Hi!
(I am very novice in MySQL)
Is it possible create view(virtual table?) from distinct values of main tables ? Or I always must create two real tables with foreign key ?
Example :
I have main table:
ID| Name| City
1 | Ivan | Moscow
2 | Dmitry | Moscow
3 | John | New York
Can I have...
No, no, no (perhaps my english so bad ?)
I don't want use CD ! I want use DVD.
And I don't want use "WebStart" or "Jump start"
I want use Solaris Interactive Installation Program ( CLI ) :
http://docs.sun.com/db/doc/816-2411/6m8ou8s7c?a=view
Have you see difference ?
I have no mouse, keyb...
Hi!
We bought V440 server and got Solaris8 box with it.
In that box threre are one DVD and many CD with OS Solaris8
and other additional software.
Previously I always install Solaris from Solaris 8 Software 1 of 2 CD
with CLI setup program. But whet I do "boot cdrom" from DVD
I always get...
Yes, I have firewall CheckPoint (moreover - with NAT) in the middle.
I seem you made a right guess wallace88.
But very strange - when I twice made by hand
"savegrp -v [-l level] -G group_name"
/bigsaveset saved once each time.
What may be with firewall ?
It is really saved twice - always with big saveset.
I have some clients with big savesets and this happened
on each of them.
I am sure that it is not index problem - it also
happened on just installed server on first backup.
With 2-3 Gb savesets on same client everything OK..
Anybody has...
I have next strange legato behaviour - big savesets with full backup saved twice.
Although small savesets (~<10Gb) on this client saved once.
This happened both 6.0 and 6.1.
03/26/04 11:47:38 nsrd: client:/bigvolume saving to pool 'ClientPool' (device01)
03/26/04 13:29:22 nsrd...
I have 2Tb IDE -> SCSI RAID connected to solaris/sparc8
with legato network edition 6.1
Initially I want create many volumes with size ~20-30Gb (like
DD3 tapes which I used before). But (thanks 605) then I find out
that my network edition support only 16 devices. So I want create
16 big volumes...
HI!
I have 6.1 backup server. I created ~50 file devices
without restarting server and long time work with them.
But when I reboot server it didn't started and hang on
nsrlmc. And in daemon.log next:
00/00/04 10:10:08 nsrd: server notice: started
00/00/04 10:12:00 nsrmmdbd: media db is cross...
HI.
Which compilers support "Variadic Macros"
(as described in C99 standart) ?
Example:
#define eprintf(format, ...) fprintf (stderr, format, __VA_ARGS__)
I have :
#gcc(3.2.2) - OK
#(Sun WorkShop 6) - NOT OK
Here is several-years working ipfilter's rules for backup host from BACKUP server
pass in quick proto tcp from BACKUP to any port 7936 >< 9937 flags S/SA keep state
pass in quick proto tcp from BACKUP to any port = 514 flags S/SA keep state
pass in quick proto tcp from BACKUP to any port = 111...
HI!
I am looking for external rackmount RAID box
with IDE interface to discks and SCSI to host.
It must has the folowing options:
1) External(host) interface : dual-host LVD SCSI
2) Discs - hot-swap IDE
3) num. of discs - >=8
4) min size - >=500Gb
5) RAID levels - 0-5
6) full backup in power...
Hi.
Time to time some save_sets don't recycling automatically and therefore
whole volume cannot set "recycled" flag.
In listing below the save_set with ssid=3714926849 is a typical example.
It has a flag "b" (browsable) instead "E" (eligible), although its
browse...
HI!
Does anybody know what exactly purpose of the files which are
in the /nsr/mm/mmvolume6 directory ?
I have over there:
VolHdr
ss*
temp_*
vol*
What defference between clients, clients.0, clients_i0, etc ?
Can I directly (whith any nsr* or mm* tools) look into clients* or ss* files ?
I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.