Blogs

Stay ahead with the latest trends in custom software development. Explore how AI, automation, and cloud solutions are shaping the future of business technology.

Select the next available value in a table

Select the next available value in a table Let’s say I have a table like this: ID Value ———————- 100 val1 101 val2 104 val3 105 val4 107 val5 [sql] SELECT Min(r1.uid) + 1 AS next_available_uid FROM unixuid AS r1 LEFT OUTER JOIN unixuid AS r2 ON r2.uid = r1.uid + 1 WHERE r1.uid > […]
Continue Reading

Datacentre – classifications

Datacentre – classifications Tier Level Requirements 1 Single non-redundant distribution path serving the IT equipment Non-redundant capacity components Basic site infrastructure guaranteeing 99.671% availability 2 Fulfils all Tier 1 requirements Redundant site infrastructure capacity components guaranteeing 99.741% availability 3 Fulfils all Tier 1 & Tier 2 requirements Multiple independent distribution paths serving the IT equipment […]
Continue Reading

Copying a filesystem with Veritas

Copying a filesystem with Veritas This procedure is to create an exact copy of a Veritas filesystem. You will need enough spare disks in your volume group, and ideally anything using the filesystem should be killed. create a mirror # vxassist -g tier3dg mirror tier3fs # vxprint tier3fs Disk group: tier3dg TY NAME ASSOC KSTATE […]
Continue Reading

VxVM – Volume Management

Volume Management Add a volume (Normal UFS mounted filesystem) # # vxassist -g datadg maxsize # # iostat -En > /tmp/iostat_en_<date> # # devfsadm # # iostat -En > /tmp/iostat_en_<date>.NEW # # luxadm probe # If no disk appears add disk manually ## # vxdmpadm listctlr all ## # cfgadm -c configure c2 ## # […]
Continue Reading