IBM Support

PureData System for Analytics How to bring database online after User has deleted /tftpboot directory in mistake.

Technote (troubleshooting)


Problem(Abstract)

User has deleted /tftpboot (Trivial File Transfer Protocol boot) directory in mistake. So he is not able to bring the database online.

Symptom

nz@osisdwh startupsvr]$ nzstart -i
ERROR: The DHCP config (/etc/dnsmasq.d/nps) references an invalid
PXE bootloader '/tftpboot/linux-install/pxelinux.0': No such file or directory
[nz@osisdwh startupsvr]$


Cause

User has deleted /tftpboot directory in mistake

Environment

Skimmer

Diagnosing the problem

We were not able to bring the database 'online', received below error.......


nz@osisdwh startupsvr]$ nzstart -i
ERROR: The DHCP config (/etc/dnsmasq.d/nps) references an invalid
PXE bootloader '/tftpboot/linux-install/pxelinux.0': No such file or directory
[nz@osisdwh startupsvr]$

Resolving the problem

The system has been configured with standard configuration............


cat /etc/hosts...........................

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 netezza localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
# do not change the following entries
#
#192.168.15.15 NZ10173.netezza.com NZ10173
192.168.88.75 osisdwh.osissoftware.com osisdwh # host1
88.255.250.116 mailhost
# Netezza Version 4.8
#
# the following entries define the ip addresses and names
# for the internal network components
#
# Management Network: 10.0.128.0/22
# netmask: 255.255.252.0
# reserved address range: 10.0.128.1 ~ 10.0.131.254
# reserved addresses per chassis: 16
#
10.0.128.1 ha1fabricright # host 1 management fabric right
10.0.128.1 ha1fabricleft # host 1 management fabric left
10.0.128.2 ha2fabricright # host 2 management fabric right
10.0.128.2 ha2fabricleft # host 2 management fabric left

--------------------------------------------------------------------------------------------------------------------------------
tftp ----------Trivial File Transfer Protocol............

The SPU use tftp to get the Linux image - meta data about the image.

Since its a Skimmer, we have to move the boot image from the kit into right place. It is better we
grab the directory structure from the same type MODEL.
We have to provide customer the tar ball of following files and directory from out lab Skimmer.

root@Nz10025 linux-install]# ls -ld *
drwxr-xr-x 2 root root 4096 Sep 15 2011 msgs
-rw-r--r-- 1 root root 13100 Dec 20 2005 pxelinux.0
drwxr-xr-x 2 root root 4096 Apr 7 2008 pxelinux.cfg
[root@Nz10025 linux-install]# pwd
/tftpboot/linux-install

Copy the tar ball as user root to / directory
then rm -rf /tftpboot
tar xvfzp tftpboot.tgz
make sure you have that "p" in the command line

As user has tried to reinit the system to bring the database 'online'

They have to start at the top with below commands.................

nzinitsystem -reinit

nzstart -newSystem

If user didn't try to reinit then they just have to start the database with 'nzstart'

Note on clustered systems TF/MK/STR you should be able to source the /tftpboot directory structure from the other host in the PDA

Historical Number

PMR 01907
001
862

Document information

More support for: PureData System for Analytics
IBM Netezza Analytics

Software version: 1.0.0

Operating system(s): Platform Independent

Software edition: Edition Independent

Reference #: 1968375

Modified date: 06 October 2016