Skip to content

Archive for

How to restart viewpoint services ?

If you have to restart Teradata viewpoint then you need to login to the viewpoint server using Putty. Once logged in you have to run below commands to restart viewpoint:

  • Navigate to /etc/init.d directory. This is the path where init files for viewpoint services are stored
  • Now run /etc/init.d/viewpoint restart  command to restart viewpoint services

Other options you can use is stop, start & status.

NOTE: I takes only 1-2 minutes to restart. Below is the progress how you will see when restarting:

# /etc/init.d/viewpoint restart
Shutting down Viewpoint done
Starting Viewpoint done

Then check the status back using below command:

# /etc/init.d/viewpoint status
Checking for Viewpoint: running

How to replace a failed disk in Netezza

Steps to follow for failed disk replacement in Netezza Twinfin appliance.

1) It is always good to first turn off all the lights for all disks beacuse its possible that someone may have left it ON during previous replacement and that may create confusion to IBM SSR.

NOTE: Below command will only affect disks and not other hardware types.

for hwid in `nzhw -type disk | tr -s ” ” | cut -d ” ” -f 2`; do nzhw locate -off -id $hwid; done

2) Now identify the failed disks that needs to be replaced

nzhw -issues
Description HW ID Location Role State
———– —– ——————– —— —–
Disk 1111 spa1.diskEncl4.disk9 Failed Ok

3) Turn on the LED for the failed drives:

nzhw locate -id 1111

Turned locator LED ‘ON’ for disk: Logical Name:’spa1.diskEncl4.disk9′ Physical Location:’1st rack, 4th disk enclosure, disk in Row 3/Column 1′.

4) Notify IBM SSR to go ahead with disk replacement.

5) Once step 4 is done run “nzhw -issues” and you will see a new hwid. The new drives will have the highest hwid’s in the system (with every new hardware added to system, it gets the hwid = current max hwid + 1)

5) After the new drive is recognized by NPS, activate the drive.

nzhw activate -id

Now nzhw -issues should not list these drives

6) Turn the lights off on the disks using the new hwid’s:

nzhw locate -off -id