MOVING ZFS FILESYSTEMS BETWEEN POOLS

MOVING ZFS FILESYSTEMS BETWEEN POOLS

APPLIES TO : Solaris zpool and zfs

GOAL :  Move a user's home directory from zfs root pool to another zpool, In this example a users home directory is mapped under root pool and it contains 6GB of data, now they need 500GB space for their home directory,

SOLUTION : Create another zpool with new 500Gb disks, Take sanpshot of existing zfs volume, use zfs send and receive command to send the snapshot data to the new zpool, Modify the mount point to new zfs volume.

1.     Create a new zpool zfs volume with 500GB new disk

                    zpool create -f -m /appuser_home appuser_home c1d25

                           

2.     Take snapshot of existing zfs volume.

                    zfs snapshot rpool/export/home/appuser@snapshot1

3.     Send the snapshot data to the new zfs volume.

                    zfs send rpool/export/home/appuser@snapshot1 | pv | zfs receive -F appuser_home

                                        # The pv command will show the status of data copy

                                        # 6.5GB of data copied in less than two minutes

                                                # 6.51GB 0:01:59 [  56MB/s] [                  <=>                               ]

4.     Unmount the existing volume.
                    zfs unmount rpool/export/home/appuser

5.     Set the mount point to new zfs volume
                    zfs set mountpoint=/export/home/appuser appuser_home



~Judi~

Excel :- Sum Only Negative Values In A Given Range Using sumif

Microsoft Excel :- Excel Sum Only Negative Values In A Given Range Using sumif command in excel.

APPLIES TO : Microsoft Office Excel

GOAL :  Summing only the negative values in a range of values sounds like a difficult task, but there's a simple solution-use SUMIF(). In fact, you can use this function to sum all the negative or positive values in the same range.
SYNTAX : SUMIF(range, criteria, [sumrange])

SOLUTION : When summing only the negative or positive values in the same range, you don't need the optional sumrange argument. Simply use one of the following simpler forms:

EXAMPLE : =SUMIF(E2:E13,">0")  --> Sums all cell values which is greater than value 0
                    =SUMIF(E2:E13,"<0")  --> Sums all cell values which is smaller than value 0


=SUMIF(E2:E13,"<0") --->Sum all the cells contains "-" (Minus) values

=SUMIF(E2:E13,">0") ---> Sum all the cells contains "+" (Positive) values





~Judi~