运维工程师必备Linux命令实战指南

版权申诉
0 下载量 187 浏览量 更新于2024-11-07 收藏 120KB ZIP 举报
资源摘要信息:"Linux操作系统是目前最流行和广泛使用的开源操作系统之一,在服务器市场中占据主导地位。对于运维工程师而言,掌握Linux系统是其职业发展的基础技能。文件“Linux-order.zip_运维”为一份压缩文件,解压缩后包含一个名为“运维工程师必会的109个Linux命令.doc”的文档,其内容涉及了运维工程师在日常工作中需要熟练使用的109个Linux命令。这些命令覆盖了从基础操作、系统管理到网络服务配置等多个方面,对于提高运维效率和质量至关重要。 在这份文档中,运维工程师可以了解到Linux系统的许多重要知识点: 1. 基础命令:包括文件和目录操作(如cd, ls, cp, mv, rm等)、文本处理(如cat, grep, sed, awk等)、压缩和解压缩(如tar, gzip, zip等)以及权限管理(如chmod, chown, chmod等)。 2. 系统信息与监控:例如查看系统信息(uname, df, du, ps等)、监控系统性能(top, htop, vmstat, iostat等)、查看和管理进程(pgrep, pkill, kill等)。 3. 软件包管理:在Linux系统中,软件包管理器的使用是安装、更新和移除软件的基础,文档中可能包含对apt, yum, dnf等包管理器使用的介绍。 4. 网络配置和故障排除:运维工程师需要熟练使用网络相关命令(ifconfig, ip, netstat, ping, telnet, ssh, scp等)来进行网络配置、故障检测和问题解决。 5. 自动化脚本编写:Linux命令是编写shell脚本的基础,自动化脚本可以大大减轻运维工作量,提高工作效率。文档可能包含对shell脚本编写的基础知识、逻辑控制(如if, for, while等)以及函数的使用。 6. 系统启动与服务管理:了解如何管理Linux系统的启动过程和服务(如init, systemd, service, systemctl等),对确保系统稳定运行至关重要。 7. 安全与备份:涉及用户管理(useradd, usermod, groupadd, passwd等)、防火墙配置(iptables, firewalld等)和备份恢复(tar, rsync等)。 8. 调试与故障排除:包括使用strace, dmesg, journalctl等工具进行系统和应用程序的调试和故障排查。 9. 系统维护:定期执行的系统维护任务,如磁盘检查(fsck)、定时任务(cron)和日志轮转(logrotate)。 这些Linux命令的知识点对于运维工程师来说,是日常工作中不可或缺的技能。掌握这些命令不仅可以提高个人的工作效率,还能够使运维工程师在面对各种系统问题时能够迅速有效地进行处理,确保业务的连续性和稳定性。文档中提到的这些命令和知识点是运维工程师日常工作中的实用工具,无论对于初学者还是有经验的运维人员来说,都是值得深入学习和熟练掌握的内容。"

请帮我看看这个sql语句是否正确,并改正:select a.ebeln, a.ebelp, a.art, a.kdauf, a.zbw, a.size1, a.txz01, a.menge, b.quantity, (a.menge - b.quantity) as OWE_MATERIAL, ( select sum(THIS_PLAN_QTY) as HAVE_PLAN , a.ebeln , a.ebelp , a.kdauf from SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c , SCM_PROCESS_PURCHASE_ORDER_D a group by c.order_no , c.order_seq , c.sales_order , a.ebeln , a.ebelp , a.kdauf having c.order_no = a.ebeln And c.order_seq = a.ebelp And c.sales_order = a.kdauf ) , ( select a.menge - t.HAVE_PLAN as OWN_PLAY from (select sum(THIS_PLAN_QTY) as HAVE_PLAN , c.order_no , c.order_seq , c.sales_order from SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c , SCM_PROCESS_PURCHASE_ORDER_D a group by c.order_no , c.order_seq , c.sales_order , a.ebeln , a.ebelp , a.kdauf having c.order_no = a.ebeln And c.order_seq = a.ebelp And c.sales_order = a.kdauf ) t , SCM_PROCESS_PURCHASE_ORDER_D a where a.ebeln = t.order_no and a.ebelp = t.order_seq and a.menge = t.sales_order ) , d.scan_qty, (d.quantity - d.scan_qty) as OWN_PRODUCE, e.scan_qty, (e.quantity - e.scan_qty) as OWE_SHIP from SCM_PROCESS_PURCHASE_ORDER_D a left join MMS_INOUT_BILL_M b On a.ebeln = b.purchase_order_number And a.ebelp = b.purchase_order_seq And a.kdauf = b.sales_order left join SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c on a.ebeln = c.order_no And a.ebelp = c.order_seq And a.kdauf = c.sales_order left join SCM_PROCESS_OUTPUT d on a.ebeln = d.order_no And a.ebelp = d.order_seq And a.kdauf = d.sales_order left join SCM_OUTSOURCE_SHIP e on a.ebeln = e.qr_code and a.ebelp = e.order_no and a.kdauf = e.order_seq where a.art = 'IE7181' Order by a.ebeln desc, a.ebelp;

2023-05-24 上传
2023-07-13 上传

insert overwrite table discountdw.dwd_sd_adds_order_bill_inc partition(dt = '2023-06-06') select t1.order_bill_id, t1.counterfoil_no, t1.acceptor, date_format(to_utc_timestamp(cast(t1.expiry_date as bigint) ,'GMT-8'),'YYYY-MM-dd'), t2.company_id, t1.cert_no, t1.company_name, t1.third_order_id, t1.counterfoil_amt/10000, t1.transaction_amt/10000, t1.rate, '3bp' as service_tariffing, ((DATEDIFF(to_utc_timestamp(t1.expiry_date ,'GMT-8'),to_utc_timestamp(t1.transaction_date ,'GMT-8') ) + adjust_days)* 0.0003 *(counterfoil_amt))/ 360 as service_fee, 360 as total_days, DATEDIFF(to_utc_timestamp(t1.expiry_date ,'GMT-8'),to_utc_timestamp(t1.transaction_date ,'GMT-8') ) + adjust_days as modulation_date, t3.channel_type, t3.bank_name, date_format(to_utc_timestamp(cast(t1.transaction_date as bigint) ,'GMT-8'),'YYYY-MM-dd'), t1.order_status_code, t1.order_status_msg, t4.fee_amt, t4.status, t1.tenant_id, t5.revenue, to_utc_timestamp(cast(t1.create_date as bigint) ,'GMT-8'), to_utc_timestamp(cast(t1.update_date as bigint) ,'GMT-8') from (select * from discountdw.ods_adds_order_bill_inc where dt ='2023-06-06' and channel_id=101110004 )t1 left join (select * from mecdw.ods_company_full where platform_id='sdpjw')t2 on t1.cert_no=t2.cert_no and t1.tenant_id=t2.tenant_id left join discountdw.dim_adds_product_full t3 on t1.partner_id=t3.partner_id and t1.product_id=t3.product_id left join (select * from mecdw.dwd_sc_fee_record_full where dt='2023-06-06' and biz_type=2 ) t4 on t1.order_bill_id=t4.third_id left join (select * from discountdw.ods_sd_order_ext_inc where dt='2023-06-06') t5 on t1.order_bill_id=t5.order_bill_id left join sdpjwdw.dim_holiday_info_full t6 on date_format(to_utc_timestamp(t1.expiry_date ,'GMT-8'),'YYYY-MM-dd') = t6.civic_holiday ;

2023-06-09 上传